| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Subtract a future month from the current month to get remaining m. | Excel Worksheet Functions | |||
| Retrieve data for previous 3, 6, 12 month given current month | Excel Worksheet Functions | |||
| saving workbook to destination file automatically | Excel Worksheet Functions | |||
| Can I automatically enter the current date or current time into a | New Users to Excel | |||
| automatically update chart plotting current month and previous 6 | Charts and Charting in Excel | |||
Linear Mode
