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

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