Workbooks Property
Collapse the table of content
Expand the table of content

Application.Workbooks Property (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Returns a Workbooks collection that represents all the open workbooks. Read-only.

expression .Workbooks

expression A variable that represents an Application object.

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") will return the open add-in named "Oscar.xla" as a Workbook object.

Note Note

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.

This example activates the workbook Book1.xls.


This example opens the workbook Large.xls.

                      Workbooks.Open filename:="LARGE.XLS"

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
© 2016 Microsoft