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

[Jim Lynch]

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]

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