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

"gold" wrote in message
...
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.






--
Gold