This documentation is archived and is not being maintained.

Workbooks Members 

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

The following tables list the members exposed by the Workbooks type.

  Name Description
Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Count Returns the number of objects in the collection. Read-only Integer.
Creator Returns a 32-bit integer that indicates the application in which this object was created. If the object was created in Microsoft Excel, this property returns the string XCEL, which is equivalent to the hexadecimal number 5843454C. Read-only XlCreator.
Item Returns a single object from a collection.
Parent Returns the parent object for the specified object. Read-only.

  Name Description
Add Creates a new workbook. The new workbook becomes the active workbook. Returns a Workbook object.
CanCheckOut True if Microsoft Excel can check out a specified workbook from a server. Read/write Boolean.
CheckOut Copies the specified workbook from a server to a local computer for editing.
Close Closes the object.
GetEnumerator Returns an enumerator to support iterating through the collection.
Open Opens a workbook.
OpenDatabase Returns a Workbook object representing a database.
OpenText Loads and parses a text file as a new workbook with a single sheet that contains the parsed text-file data.
OpenXML Opens an XML data file. Returns a Workbook object.