Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
khalid
 
Posts: n/a
Default 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.
  #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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i create an excel file using asp Farooq Excel Discussion (Misc queries) 0 March 15th 05 11:09 AM
Locating a file in excel with a partial file name. Audra Excel Discussion (Misc queries) 0 February 19th 05 02:03 PM
How do I make a backup file of my excel document? Starrystella Excel Discussion (Misc queries) 1 January 7th 05 07:43 PM
double click a xls file and start Excel but without the file Danyi, Attila Excel Discussion (Misc queries) 2 December 22nd 04 02:19 PM
Creating a PDF file programatically from Excel Chaplain Doug Excel Discussion (Misc queries) 0 December 16th 04 08:49 PM


All times are GMT +1. The time now is 03:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"