Applies To
Workbook Object.
Description
Saves a copy of the workbook to a file but does not modify the open workbook in memory.
Syntax
object.SaveCopyAs(filename)
object
Required. The Workbook object.
filename
Required. Specifies the filename for the copy.
See Also
Save Method, SaveAs Method.
Example
This example saves a copy of the active workbook.
ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"
This is the same example in Microsoft Excel for the Macintosh.
ActiveWorkbook.SaveCopyAs "HD:Temporary Folder:Temporary Workbook File"