Excel.Workbook.SaveCopyAs.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.SaveCopyAs method (Excel)	vbaxl10.chm199146	vbaxl10.chm199146	Excel.Workbook.SaveCopyAs	84f58488-6a2b-7fef-1472-e1b9771a60b0	05/29/2019	medium

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	Required	Variant	Specifies the file name for the copy.

Example

This example saves a copy of the active workbook.

ActiveWorkbook.SaveCopyAs "C:\TEMP\XXXX.XLS"

[!includeSupport and feedback]