Workbook.SaveCopyAs Method
| Excel Developer Reference |
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.
| Visual Basic for Applications |
|---|
|
See Also