Returns a Workbooks collection that represents all the open workbooks. Read-only.
Syntax
expression.Workbooks
expression A variable that represents an Application object.
Remarks
Using this property without an object qualifier is equivalent to using Application.Workbooks.
The collection returned by the Workbooks property doesn't include open add-ins, which are a special kind of hidden workbook. You can, however, return a single open add-in if you know the file name. For example, Workbooks("Oscar.xla") returns the open add-in named "Oscar.xla" as a Workbook object.
A workbook displayed in a Protected View window is not a member of the Workbooks collection. Instead, use the Workbook property of the ProtectedViewWindow object to access a workbook that is displayed in a Protected View window.
Example
This example activates the workbook Book1.xlsx.
Workbooks("BOOK1.xlsx").ActivateThis example opens the workbook Large.xlsx.
Workbooks.Open filename:="LARGE.XLSX"This example saves changes to and closes all workbooks except the one that's running the example.
For Each w In Workbooks
If w.Name <> ThisWorkbook.Name Then
w.Close savechanges:=True
End If
Next w