Workbooks Collection Object

Description

A collection of all the Workbook objects currently open in the Microsoft Excel application.

Accessors

Use the Open method to open a file. Use the Add method to create a new empty workbook and add it to the collection. The following example adds a new empty workbook to Microsoft Excel (this is equivalent to clicking the New command on the File menu).


Workbooks.Add

The following example opens the file ARRAY.XLS as a read-only workbook.


Workbooks.Open fileName:="array.xls", readOnly:=True

Use the Workbooks method with an argument to access a single member of the collection or without an argument to access the entire collection at once. The following example closes all open workbooks.


Workbooks.Close

Properties

Application Property, Count Property, Creator Property, Parent Property.

Methods

Add Method (Workbooks Collection), Close Method, Item Method, Open Method, OpenText Method.