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.

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

--
HTH

Bob Phillips

"khalid" <khalid@discussions.microsoft.com> wrote in message
news:A442EDF2-66D9-4F8E-A36D-13CFE12A22F3@microsoft.com...
> 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.