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