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