Breaking

Sunday 20 May 2018

VBA Excel VBA - Close all workbooks at once

Excel VBA - Close all workbooks at once

by on in

Copy & Paste the following code in Excel VBA.
Sub CloseAllWorkbooks()
Dim wbs As Workbook
For Each wbs In Workbooks
wbs.Close SaveChanges:=True
Next wb
End Sub

Sub CloseAllWorkbooks()
Dim wbs As Workbook
For Each wbs In Workbooks
wbs.Close SaveChanges:=True
Next wb
End Sub


By at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)