| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving date as part of filename
Hi all
I am using Excel 2000 and I want to assign a routine to a button that takes a name from one cell and a date from another and passes this to the Saveas routine. The idea is that I will end up with a copy of the original file that has a name such as MyFile070308.xls. However, when I try this the date gets re-formatted into the number of days since 01/01/1900. Any ideas? Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving with Today's date as part of the string | Excel Programming | |||
| Automatically saving an Excel spreadsheet with today's date in the filename | Excel Programming | |||
| Saving with date in filename | Excel Programming | |||
| Saving filename same as import filename | Excel Programming | |||
| Get a part of a filename | Excel Programming | |||
Threaded Mode
