Saving file as current month name automatically

G

gold

I have folder which contains 40 different worksheets for each depatment which
I want to be able to save it automatically as that month's name in the folder
for that month. So that way, I don't have to manually do save as for 40
files. Can someone please help me with automizing this.
 
Z

Zone

Some more info would be helpful, like the name format of the folder (Files
March 2007, March 07 Files, Files 03-07, same for the files in the folder.
James
 
Top