I need to batch copy 286 files, but the VBA code needs to be slightly different in each one. Here's an example of my code: Workbooks.Open ("\\directory\Reports\Ridership 2015 06 (Jun).xlsx") . The files where the code is located will be named with individual dates, such as "Reports 06-06-15". I am wanting to have a single template for my batch copy where Ridership YYYY MM (MMM).xlsx") references the originating file's name. Is there a way for me to make copies while changing the code from Ridership 2015 06 (Jun).xlsx") to Ridership 2015 07 (Jul).xlsx"),Ridership 2015 08 (Aug).xlsx"), and so on?

I already know how to make a .bat to copy files, so please don't explain that process.