ExcelBanter - How do I Create backup of excel file in other folder

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I Create backup of excel file in other folder (https://www.excelbanter.com/excel-discussion-misc-queries/27436-how-do-i-create-backup-excel-file-other-folder.html)

khalid

How do I Create backup of excel file in other folder

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.

Bob Phillips

Using VBA< you can use the SaveCopyAs method and specify the target.

--
HTH

Bob Phillips

"khalid" wrote in message
...
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.

All times are GMT +1. The time now is 05:35 AM.