Backing up Excel file
Hello all,
Is there another way to back up an Excel file, besides the AutoRecover settings in Options and the Always Create Backup feature in the General Options of Save As? What I am looking to do is to create a backup copy automatically in a directory that I want (other than the directory where the original is). Thanks. |
Backing up Excel file
Use windows explorer and just copy|paste?
AccessHelp wrote: Hello all, Is there another way to back up an Excel file, besides the AutoRecover settings in Options and the Always Create Backup feature in the General Options of Save As? What I am looking to do is to create a backup copy automatically in a directory that I want (other than the directory where the original is). Thanks. -- Dave Peterson |
Backing up Excel file
Dave,
Thanks for your response. I am looking for something to create a backup automatically. The "Always Create Backup" does create a backup automatically, but the backup is saved in the same folder as the original. I didn't find an option for me to select a directory to save the backup. "Dave Peterson" wrote: Use windows explorer and just copy|paste? AccessHelp wrote: Hello all, Is there another way to back up an Excel file, besides the AutoRecover settings in Options and the Always Create Backup feature in the General Options of Save As? What I am looking to do is to create a backup copy automatically in a directory that I want (other than the directory where the original is). Thanks. -- Dave Peterson |
Backing up Excel file
First, autorecovery doesn't create backups that you can use. It's there to
catch windows/excel crashes. AutoSave (from xl2k and previous versions) would overwrite the existing file--so that's out. But... You may want to consider using Jan Karel Pieterse's addin 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. So it still requires some vigilance on your part. http://www.jkp-ads.com/Download.htm (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.) ==== Maybe you could use a .bat file that would copy the files you want backed up. Just create the .bat file, put a shortcut on your desktop and run that whenever you want. David McRitchie has some notes you may want to review: http://mvps.org/dmcritchie/excel/backup.htm In fact, he has some code that you may like that could be used for backing up. AccessHelp wrote: Dave, Thanks for your response. I am looking for something to create a backup automatically. The "Always Create Backup" does create a backup automatically, but the backup is saved in the same folder as the original. I didn't find an option for me to select a directory to save the backup. "Dave Peterson" wrote: Use windows explorer and just copy|paste? AccessHelp wrote: Hello all, Is there another way to back up an Excel file, besides the AutoRecover settings in Options and the Always Create Backup feature in the General Options of Save As? What I am looking to do is to create a backup copy automatically in a directory that I want (other than the directory where the original is). Thanks. -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 01:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com