Copying Entire Excel Workbooks

[jheit]

Fairly new user here- I apologize for any miscommunications.

In summary, is there any way in Alteryx to copy an entire Excel workbook to another location? I know it can be copied sheet-by-sheet, but I am looking for a more efficient way of doing so.

Here's my situation: I have an Excel workbook (template) that contains 10 sheets. Every quarter, 5 of those sheets are updated using the workflow. The other 5 sheets contain Pivot Tables that are not directly updated, but read values from the 5 updated sheets when refreshed.

The output will go to a new location each quarter that will not have the Excel template (this location is dependent on a Text Box interface tool). I understand I could write a batch file to complete this copy-and-paste before the workflow is run, but it will not be dynamic and adjusted by the Text Box interface tool. I could also manually copy-and-paste it, but I am trying to remove human errors from the process. My workflow is an analytic app. Any suggestions?

[ArtApa]

Hi @jheit - You can use a Run Command tool:

Please read the following:

• https://help.alteryx.com/current/designer/run-command-tool 
• https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Move-jpeg-files-to-different-folder-de... 

[danilang]

Hi @jheit 

As well as using the Run command, you can also use the Blob tools to copy files.  See @patrick_digan's, answer in this post

Dan

[jheit]

Does the Run Command tool still work properly when uploaded to the Alteryx galleries? I have using the %temp% directory in the Run Command and want to make sure this method is unaffected by a gallery upload.