Copying data where root file changes

[sharp_shooter]

Hi

I need a macro to copy from one sheet to another, however the root file will change every month so is this possible?

For example –
Copy data from X:/abc/def/Jan 15/Data/Datafile.xls
Paste to X:/abc/def/Jan 15/123/123.xls
The folder “Jan 15” will change every month so when I do it next I will have “Feb 15” however the macro I did for the files in “Jan 15” will no longer be valid for Feb as the root file has changed.

Any ways round this?

Hope this makes sense

Many Thanks.

[LJMetzger]

Hi sharp_shooter,

Yes, there are many ways to do what you want. See the attached file which implements the code that follows. The file has 3 options:
a. Generate file specifications for the 15th of the current month.
b. Generate file specifications for the 15th of the previous month.
c. Generate file specifications for the 15th of a custom month (Jan thru Dec).

Please let me know if you need additional help, since your question was a little vague.

Lewis

Please Login or Register  to view this content.