Workbook.SaveCopyAs method (Excel)
Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.
expression.SaveCopyAs (FileName)
expression A variable that represents a Workbook object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| FileName | Required | Variant | Specifies the file name for the copy. |
This example saves a copy of the active workbook.
VB
ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.