| 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 |
| 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 | |||
Threaded Mode
