Saves changes to the specified workbook.
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.
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