EXCEL-LENCY
Board Regular
- Joined
- Feb 9, 2010
- Messages
- 75
Hello,
As part of a larger macro, I need to make a copy of a file when another process has completed. High level, I have a folder that contains many individual forecasts. I created a macro that captures each forecast in that folder and summarizes it for an overall forecast. As the loop creates a snapshot of each forecast, I need to make a copy of that file and paste it in another folder. All of the forecast files are in the following directory:
\\cest.home\cest\forecasts
I need to copy the each forecast into a new folder as the snapshots are taken. The second directory is:
\\cest.home\cest\cforecasts
In easy terms, how can you copy a file to another folder?
Any help would be greatly appreciated, as this would save me tons of time each month!
Thanks in advance!
Jason
As part of a larger macro, I need to make a copy of a file when another process has completed. High level, I have a folder that contains many individual forecasts. I created a macro that captures each forecast in that folder and summarizes it for an overall forecast. As the loop creates a snapshot of each forecast, I need to make a copy of that file and paste it in another folder. All of the forecast files are in the following directory:
\\cest.home\cest\forecasts
I need to copy the each forecast into a new folder as the snapshots are taken. The second directory is:
\\cest.home\cest\cforecasts
In easy terms, how can you copy a file to another folder?
Any help would be greatly appreciated, as this would save me tons of time each month!
Thanks in advance!
Jason
