_Application.Save(Object) Method
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Saves changes to the specified workbook.
public void Save (object Filename);Public Sub Save (Optional Filename As Object)Parameters
- Filename
- Object
Examples
This example saves the active workbook.
<span class="label">ActiveWorkbook.</span>
<i>Save</i>
This example saves all open workbooks and then closes Microsoft Excel.
<span class="label">For Each w In Application.Workbooks w.</span>
<i>Save</i>
<span class="label">Next w Application.Quit</span>
This example saves the active workbook.
<span class="label">ActiveWorkbook.</span>
<i>Save</i>
This example saves all open workbooks and then closes Microsoft Excel.
<span class="label">For Each w In Application.Workbooks w.</span>
<i>Save</i>
<span class="label">Next w Application.Quit</span>
This example saves the active workbook.
<span class="label">ActiveWorkbook.</span>
<i>Save</i>
This example saves all open workbooks and then closes Microsoft Excel.
<span class="label">For Each w In Application.Workbooks w.</span>
<i>Save</i>
<span class="label">Next w Application.Quit</span>
Remarks
To open a workbook file, use the Microsoft.Office.Interop.Excel.Workbooks.Open(System.String method.
To mark a workbook as saved without writing it to a disk, set its SaveData property to True.
The first time you save a workbook, use the Microsoft.Office.Interop.Excel._Workbook.SaveAs(System.Object method to specify a name for the file.