View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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.