Save Method

Applies To

Workbook object.

Description

Saves changes to the specified workbook.

Syntax

expression.Save

expression Required. An expression that returns a Workbook object.

Remarks

To open a workbook file, use the Open method.

To mark a 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