Creating excel backup files
 

In our office we are currently running Windows 2000 and
Office Xp. We have a shared excel file that creates backup
files when the application is closed. Is there a way to
direct the .xlk file to seperate location away from the
original file through excel? Or must this be coded?

thanks in advance!!
Andrew

Creating excel backup files
 

ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"

--

John

johnf202 at hotmail dot com


"Andrew Fekete" wrote in message
...
In our office we are currently running Windows 2000 and
Office Xp. We have a shared excel file that creates backup
files when the application is closed. Is there a way to
direct the .xlk file to seperate location away from the
original file through excel? Or must this be coded?

thanks in advance!!
Andrew