Save Method

Applies To

Application Object, Workbook Object.

Description

Workbook object (Syntax 1): Saves changes to the specified workbook. Application object (Syntax 2): Saves the current workspace.

Syntax 1

object.Save

Syntax 2

object.Save(filename)

object

Required. The Workbook object (Syntax 1) or Application object (Syntax 2).

filename

Optional. Specifies the name of the saved workspace file. If this argument is omitted, a default name is used.

Remarks

To open a workbook file, use the Open method.

To mark the workbook as saved without writing it to a disk, set its Saved property to True.

The first time you save a workbook, use the SaveAs method to specify a name for the file.

See Also

Open Method, SaveAs Method, SaveCopyAs Method, Saved Property.

Example

This example saves the active workbook.

ActiveWorkbook.Save

This example saves all open workbooks and then closes Microsoft Excel.

For Each w In Application.Workbooks
    w.Save
Next w
Application.Quit