Can I auto save to a separate file?(not the file I am working in)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jim Lynch - 14 Aug 2006 15:00 GMT

I need to save my spread sheet every 30 minutes to another file that I am not
working in, and this other file will not be saved over when I save to my
working file.

Reply to this Message

Dave Peterson - 14 Aug 2006 17:20 GMT

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

> I need to save my spread sheet every 30 minutes to another file that I am not
> working in, and this other file will not be saved over when I save to my
> working file.

Signature

Dave Peterson

Reply to this Message