Workbook.Save Method

Saves changes to the specified workbook.

Syntax

expression.Save

expression   A variable that represents 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.

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

See Also

• Workbook Object
• Workbook Object Members
• SaveCopyAs Method
• Saved Property