AutoSave File After X Time In VBA

[Celtic_Avenger]

Can Someone Please Help.

I want to create a macor somewhere in my spreadsheet to automatical
save the file after a predetermined time, then the timer would the
start again, or at least once any changes are made.

Can this be done?

Thanks

Celtic_Avenger
:confused

 

[Dave Peterson]

Before xl2k, this was an addin that MS distributed with excel. It's called
AutoSave.

If you're using xl2k (or earlier), you may have to install this feature from the
distribution CD. Then enable it under Tools|addins.

AutoSave was replaced with AutoRecovery (mostly used if excel/windows crash).
It's not the same as autoSave, though.

And Gord Dibben posted this:

Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
If you have a previous copy, move it to your Office\Library.
To download the 97 version see here........
http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

As an alternative, you may want to consider using Jan Karel Pieterse's addin
called AutoSafe (note spelling).

It doesn't overwrite the existing workbook when it saves. It saves to a user
selectable folder. And when it's done, it either deletes these backups (or puts
them in the recycle bin). And the user can always restore the backups from the
recycle bin.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)