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.