| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto save at specific times with changing saveas name
I have an Excel file that I need to save-as automatically to a static
location of my choosing at 12Noon, 5:00pm & 11:59pm every day the file is used, which is every day. When save-as occurs at these times, I need the file to save with a name like "MyFile_todaysdate_1200.xls" or "MyFile_todaysdate_1700.xls" or "MyFile_todaysdate_2359.xls". I know a file can not use "/" in the filename so the date can look like 061808. I just have not been able to peice this together with what little I know along with posts I've read. I really appreciate any assistance with this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto save Spread sheet as htm to a specific location | Excel Discussion (Misc queries) | |||
| disable save and saveas from menubar and save via command button | Excel Programming | |||
| save / saveas specific filename.....with a difference! | Excel Programming | |||
| 2 Part question involving SaveAs and Auto Save when quit. | Excel Programming | |||
| Disabling Saveas and saving file with a specific name only | Excel Programming | |||
![SJW_OST[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
