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

HTH

RP
(remove nothere from the email address if mailing direct)


"Craig" wrote in message
...
Is there anyway in Excel 2003 to take a file and duplicate a file and
rename
it while leaving the original file unchanged?

Thanks