| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 | |||
Hybrid Mode
