Application.Workbooks (Excel)

Returns a Workbooks collection that represents all the open workbooks.

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.

Dim wrksWorkbooks As Workbooks
Set wrksWorkbooks = Workbooks