ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto Save (https://www.excelbanter.com/excel-programming/379337-auto-save.html)

amirstal

Auto Save
 
Other than the AutoRecover save option under Tool/Options/Save, is
there a way to create a procedure that will save the file every let's
say 30 seconds?

Thanks,

Amir


Dave Peterson

Auto Save
 
If you still have autosave.xla from a previous version of excel, it'll work with
xl2003--I don't recall if you could specify 30 seconds, though.

Jan Karel Pieterse wrote an addin (works in any version) 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.)

amirstal wrote:

Other than the AutoRecover save option under Tool/Options/Save, is
there a way to create a procedure that will save the file every let's
say 30 seconds?

Thanks,

Amir


--

Dave Peterson


All times are GMT +1. The time now is 11:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com