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
  ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"

See Also