createbackup

2 questions -
1.  In VB for Excel, can I save a workbook to another location (like with SaveAs), except maintain working with the same workbook.  By default, after the SaveAs, the working workbook is now the new SavedAs workbook.  
2.  In attempting to deal with the above issue, I added some .createbackup code.  I didn't like it because it backed up to the same folder.  I removed the code, but the setting seems to be stuck.  Whenever the code does a Activeworkbook.Save, a backup copy is also created.
Thank you.
tom_v_olsenAsked:
Who is Participating?
 
ahammarCommented:
If you don't want the backup copy to be created, then go to "Save as", then in the "Save as" window...go to "Tools" then "General Options", and uncheck the "Always create backup" box, then continue on with the save as.  The new file will no longer create a backup everytime you save it.

:-)
Albert
0
 
aikimarkCommented:
* You could make a copy of the workbook to a 'shadow' workbook, copying every worksheet.  Then save the shadow workbook.

* You could do a double save of the workbook, first as the new name and then as the current name.

* Are you trying to replace the AutoSave actions?
0
 
ahammarCommented:
Also...there is no way to save your workbook to a different folder than  the one you are currently working with is in, and still continue to work with the exact same file.   You could have it "Save" the one you are currently working with at regular intervals using a macro...or "Save as" to any folder you want, but then you will be working with the new "Saved as" file, and not the original, as you already know.

:-)
Albert
0
 
ahammarCommented:
>>You could have it "Save" the one you are currently working with at regular intervals using a macro...or "Save as" to any folder you want, but then you will be working with the new "Saved as" file, and not the original, as you already know.>>

Let me rephrase that:

You could have it "Save" the one you are currently working with at regular intervals using a macro set up as a timer, (but Excel has AutoSave options)

You could also "Save as" to any folder you want, but then you will be working with the new "Saved as" file, and not the original, as you already know.

or you could manually or write a macro to do as aikimark mentioned and do a double save of the workbook, first as the new Path and name and then as the current path and name, then you would have a copy of it in a different folder, and still be working with the same one you started with...that may be your best option if that's what you want.

:-)
Albert



:-)
Albert
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.