Hi all
I'm creating a short workflow where the user will select the file location for an output excel file but the workflow will provide the cell reference for the eventual output tool to overwrite a specific range.
At the moment, I have a File Browse -> Action -> Text input to allow the user to specify the file location.
Then a formula tool adds the fixed cell range using [Filename]+"$C4:D4"
The resulting single item is then appended to the other fields from the main dataset using the Append Fields tool.
The output tool is directed to use the field with the combined filename and cell range.
This works fine except that when I test it, the resulting excel output creates a tab with "$[Tab name]" rather than just "[Tab name]". Looking into the workflow in Designer, the above process seems to stick a $ at the end of the tab name that has been created by the Text input, separate to the $ required to specify the cell range in the formula tool. Attached is a the workflow for reference.
Try as I might, I can't get the workflow to output to the tab without the leading $. I'm certain I'm doing something wrong and I'm certain there is an easier way of doing this!
Thanks in advance.
