How to Set Path of Backp (Excel-XLK).
 

Ver:Office 2000
While Using Excel I set The backup option ON (by Save AS - Tools - General
Options - Always Create Backup Checked) so that every time I save, a backup
is created, Now my problem is that this backup file in created in the same
folder in which original file is saved. I want know how this backup file can
be created in any different Folder.

How to Set Path of Backp (Excel-XLK).
 

Hi Vikas,
I think the same directory is used because files are renamed
and the .bck extension is is mostly the same but a permanent copy is
saved. (least that's the way it seems to me)
You can create your own backup, see
Backup your files, always take backups
http://www.mvps.org/dmcritchie/excel/backup.htm#demand-
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Vikas Tandon" <Vikas wrote in message ...
Ver:Office 2000
While Using Excel I set The backup option ON (by Save AS - Tools - General
Options - Always Create Backup Checked) so that every time I save, a backup
is created, Now my problem is that this backup file in created in the same
folder in which original file is saved. I want know how this backup file can
be created in any different Folder.