Export (0) Print
Expand All

Workbook.SaveCopyAs Method

Office 2007
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

NameRequired/OptionalData TypeDescription
FilenameOptionalVariantSpecifies 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"



Community Additions

ADD
Show:
© 2015 Microsoft