| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autosave VBA
Anyone know how to use the autosave programatically within Excel?
I want to autosave every xx minutes and save multiple copies to multiple places. Paul |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Autosave VBA
Hi Paul
You can do something like ActiveWorkbook.SaveCopyAs "C:\Backups\" & _ Replace(ActiveWorkbook.Name, ".xls", "") & _ "_" & Format(Now, "ddmmm_hhmm") & ".xls" For the timer part, see http://www.cpearson.com/excel/ontime.htm HTH. Best wishes Harald "Paulymon" skrev i melding ... Anyone know how to use the autosave programatically within Excel? I want to autosave every xx minutes and save multiple copies to multiple places. Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoSave | Excel Discussion (Misc queries) | |||
| Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
| autosave | Excel Worksheet Functions | |||
| Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
| Removing AUTOSAVE.XLS(AUTOSAVE.XLA) from VBA editor??? | Excel Programming | |||
Linear Mode
