This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have attached my sample workflow to this post where I am trying to just write a batch file to copy a template .xlsm file to a different location (from the C Drive / Desktop to the C Drive / Documents folder for now - want to perfect this before changing these to my network server locations) and also to rename the copied file with a date suffix.
Please note that in the directory tool I have taken out my "Username" value between "Users\" and "Desktop" and "Documents" to remove my identity from this data - this will likely need to be changed to your username on your computer before you can test this workflow.
The workflow is supposed to write a batch script file to the C:\Users\Desktop location that's contents are below and then run that script.bat file as the 2nd part of the "Block Until Done" tool.
Unfortunately, I have only been able to get the workflow to output the "output.csv" file and copy the .xlsm file from the Desktop to the Documents folder, but the copy from the Documents folder to the Documents\My Received Files location has never worked and neither has the rename (obviously since the file never gets copies to the "My Received Files" location). I am constantly getting an error code 4 as part of the Run Command, which apparently means the system cannot open the .bat file for some reason.
Ultimately, if I am able to get this entire container fixed and working on my C drive, I'm almost positive I can attach this to my workflow where I write three separate Output Tools to 3 separate tabs of the copied .XLSM template file.