How do I Create backup of excel file in other folder

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need the excel backup files to be saved in other folder.
I'v choosen "Always create backup" in the save option, but I have traffic in
my working folder, so I need the backup files to be in other folder.
 
Using VBA< you can use the SaveCopyAs method and specify the target.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 6
Backup Excel file 1
Excel 2007- can't get it to automatically make backups 1
automatic backup? 2007 version 3
Backup of excel 2007 files. 8
How to auto create "backup of filename.xls" in Excel 2007. 2
Backup programs. 13
backup file created 1

Back
Top