Workbook.Save Method

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