Saving file as current month name automatically
 

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

Saving file as current month name automatically
 

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

Saving file as current month name automatically
 

répertoire = ActiveWorkbook.Path
ActiveWorkbook.SaveAs Filename:=répertoire & "\File_" & Format(Date,
"dd-mm-yyyy")

JB
http://boisgontierjacques.free.fr/



On 25 août, 15:37, "Zone" wrote:
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- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -