Save before crash

  • Thread starter Thread starter Jacky Luk
  • Start date Start date
J

Jacky Luk

Hi,
I have got an Excel 2000 VBA application that sends stuff out in a batch
job. Every now and again, the app breaks down and has to be restarted again.
I sometimes lose a little bit of that or that. So how do I make Excel save
my stuff before it crashes?
Thanks
Jack
 
There is no workbook_beforecrash event that you can tie into.

You could create a macro that saves when you want. You could save more often
manually.

Or you could use Jan Karel Pieterse's addin: AutoSafe.

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.)

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.

===
xl2k also has an addin called autosave. It saves the workbook at timed
intervals. You may need your office CD to install it.

When it's installed, you can turn it on via Tools|addins.
 
Back
Top