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 |
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 |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com