Save all open Excel workbooks
This tutorial shows how to save all open Excel files at once using VBA
Sub Save_all_excel_files()
Dim wb As Workbook
For Each wb In Application.Workbooks
For Each wb In Application.Workbooks
If Not wb.ReadOnly Then
wb.Save
End If
wb.Save
End If
Next
End Sub
NOTES
Note 1: This VBA code will save all open excel files in their existing locations at once.
Note 1: This VBA code will save all open excel files in their existing locations at once.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Create and Save a new workbook | How to create and save a new workbook using VBA | |
| Save an Excel workbook | How to save an Excel workbook |