• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 645
  • Last Modified:

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.
0
tom_v_olsen
Asked:
tom_v_olsen
  • 3
2 Solutions
 
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:
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
 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now