I have an automation script that includes two embedded automation scripts.
The first script connects to a source Excel file located on a network drive and creates an Excel file with multiple tabs, which is then saved in my local C:\temp to reduce processing time.
The second script has two Copy File activities:
The first copies the newly created file (from the above script) on my C:\temp to a network drive folder and adds a timestamp suffix to the file name.
The second should copy the original source file (from the above script) to another network location adding a timestamp suffix to the file name. Then delete the original.
My automation script fails at the second Copy File activity with the following message: “The process cannot access the file because it is being used by another process”.
Is there a way of dropping the connection to the source file used in the my first script, so I can successfully copy/move this source file to another location when finished with?
I tried adding a Pause system activity (set to 120 seconds) between my two automation scripts, but still receive the failure message.
Any help advise welcome.
Thank you in advance.