Workbook.SaveCopyAs Method (Excel)
Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.
Syntax
expression .SaveCopyAs(Filename)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Filename |
Optional |
Variant |
Specifies the file name for the copy. |
Example
This example saves a copy of the active workbook.
ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"