Thread: Autosave VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 292
Default 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