SaveCopyAs Method
Applies To
Workbook object.
Description
Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.
Syntax
expression.SaveCopyAs(Filename)
expression Required. An expression that returns a Workbook object.
Filename Required. Specifies the file name 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"