How do I Create backup of excel file in other folder

khalid · May 24, 2005

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 · May 24, 2005

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

How do I Create backup of excel file in other folder

khalid

Bob Phillips