Saving file as current month name automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top