| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using macro to save as todays date
Hello,
can someone help me, I can write a macro to save the file as a single referenced cell, but can anyone help me in creating a macro which either within the macro or by referencing a cell returns a file named as "PA2005-01-05" or the date for the current day. I have used '=now()' in say cell A1 but am not sure how to put this through a macro to give me a file name saved as the format "PA2005-01-05", please any help, many thanks Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to goto specific cell (todays date) | Excel Discussion (Misc queries) | |||
| Save file as todays date | Excel Discussion (Misc queries) | |||
| Save file with todays date ref#11235 | Excel Worksheet Functions | |||
| macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
| What syntax do I use to add todays date in an excel macro | Excel Programming | |||
Threaded Mode
