Output to multiple Excel tabs and create new file each run

[NgaN]

Does anybody know how to output multiple Excel tabs and create new file (with new name) each time the workflow is run? I can do them separately (output a file with multiple tabs OR create a new file with new name, for example date stamp) but not together. Is there a way to select both Change File/Table Name and Change Entire File Path at the same time? The menu will only let me pick one at a time

[Garrett · Accepted solution]

If I understand your aim correctly "Change Entire File Path" should be able to accomplish both a new file name and new sheet names as long as you build up the entire syntax in a single field.

See attached workflow.

[NgaN]

Perfect. Thank you very much!