Using VBA to create multiple copies of a spreadsheet file with different filenames

Good morning, all. First, let me say that I don't like this setup, but the guy who did it was chosen by corporate to oversee this project and this is the way he set things up. This leaves the rest of us having to do the work part of it all, including every month creating 30 or 31 sheets for that month. As of right now, everyone creates a Day 1 (in this case, it would be named something like "X Facility 12_01_2013.xlsm") sheet. from the last day of the previous month, into a new monthly folder. Making the copies of the first day's file and then changing the file names manually gets to be a pain, especially when you have to do it for three facilities each month like I do.

So, to re-cap and summarize, here is what I would like to be able to do somehow with VBA...

Take "X Facility 11_30_2013.xlsm" in folder "\\...\2013\November\"and create 31 copies in folder "\\...\2013\December\" as "X Facility 12_01_2013.xlsm" and repeat with the only change in filename being the actual day, i.e. "12_01_2013", "12_02_2013", "12_03_2013", 12_04_2013", etc. I'm sure you get the point.

OR, if it's difficult to start with a file from another folder, I can always create the first day's file and then have the VBA code help me from that point forward. I'm just trying to get rid of the long process of copying and changing the filenames for each daily file.

Thank you!

This was EXACTLY what I was needing. Thank you very much, my friend!

Where the heck did my post go? Well, I'll try again. Thank you VERY MUCH, my friend! Worked like a charm!!