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