Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
Insert & link a graphic file in Excel 2003 -- updatable pictures! | Excel Discussion (Misc queries) | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) |