Thread: Can I auto save to a separate file?(not the file I am working in)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Can I auto save to a separate file?(not the file I am working in)
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.)

Jim Lynch wrote:

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.

--

Dave Peterson
Reply With QuoteReply With Quote