Hi Guys,
I wonder if you can help me out. I have a dumpfile macro in production at the moment which populates aprox.40 excel files located in various folders and sub-folders.
At the moment I am manually copying these files each week and changing the dates in all files and with-in the macro to match.

Im looking for a piece of code that once I enter this weeks date as a string, will change the name of all 40 files to include the new date and continue on to populate the failes as per usual.

Any ideas??
Thanks very much

Tony