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

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" <[email protected]> skrev i melding
news:[email protected]...
> 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
>