다음을 통해 공유


Workbook.SaveCopyAs Method (Excel)

Saves a copy of the workbook to a file but doesn't modify the open workbook in memory.

Syntax

.SaveCopyAs(Filename)

A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Filename

선택

Variant

Specifies the file name for the copy.

Example

This example saves a copy of the active workbook.

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

참고 항목

개념

Workbook Object

Workbook Object Members