| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file with different names
Good day,
I want to save a workbook for archive purpose, but the name of this new workbook needs to change everyday. How can I write a macro that would SAVE my new file AS newbook &"Today()".xls? I would like to have something like: ActiveWorkbook.SaveAs Filename:="C:\2007\Newbook & "Today()".xls" -- Thanks Sebastien |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save file with different names
ActiveWorkbook.SaveAs Filename:="C:\2007\Newbook " & Format(Date,"yyyymmdd")
& ".xls" -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Sebastien" wrote in message ... Good day, I want to save a workbook for archive purpose, but the name of this new workbook needs to change everyday. How can I write a macro that would SAVE my new file AS newbook &"Today()".xls? I would like to have something like: ActiveWorkbook.SaveAs Filename:="C:\2007\Newbook & "Today()".xls" -- Thanks Sebastien |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save file with different names
I worked this out yesterday after having some problems with the date
format and / ActiveWorkbook.SaveAs Filename:= _ "C:\2007\Newbook & Format(Date, " dd-mm-yyyy") & ".xls" |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save file with different names
Ian, better to put the date in year month day order as I showed, helps in
sorting the files in the folder. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "ian" wrote in message oups.com... I worked this out yesterday after having some problems with the date format and / ActiveWorkbook.SaveAs Filename:= _ "C:\2007\Newbook & Format(Date, " dd-mm-yyyy") & ".xls" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save worksheet as another file, but have all defined names copied | Excel Discussion (Misc queries) | |||
| can I save a file of multiple names to replace using excell 03 | Excel Discussion (Misc queries) | |||
| I can't save long file names, only short one, how can I do this? | Excel Discussion (Misc queries) | |||
| HOW TO SAVE FILE NAMES IN COLOUR OR DIFFERENT FONTS | Excel Worksheet Functions | |||
| Extract file names last save info from a Folder | Excel Programming | |||
Linear Mode
