I need a macro that will do the following:
MyFolder1 has 5 excel files in it. They are named:
MyFolder2 currently has 1 file in it. It is named:
Using a macro in the Testfile file, I need to make copies of the Testfile file, give each one the same name as the files in MyFolder1 and place the newly named files in MyFolder2 so that I wind up with the following in MyFolder2:
And, no I can't just make copies of the files in MyFolder1. I need to make copies of the Testfile file and rename them.
So what I'm looking for is how to cycle through MyFolder1, get the names of the files programmatically, create copies of the Testfile so that I wind up with 5 of them, rename them to match the names of the files in MyFolder1 and place the newly-created files in MyFolder2. Thank you.