ExcelBanter - Copying and renaming a file

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Copying and renaming a file (https://www.excelbanter.com/excel-discussion-misc-queries/14877-copying-renaming-file.html)

Craig

Copying and renaming a file

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

Thanks

Bob Phillips

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

All times are GMT +1. The time now is 02:48 PM.