Application.Workbooks Property

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")

Example

This example activates the workbook Book1.xls.

Workbooks("BOOK1").Activate

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

See also:

• Application Object
• Application Object Members