Share via


Workbooks Members

Include Protected Members
Include Inherited Members

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

The Workbooks type exposes the following members.

Properties

  Name Description
Public property _Default Reserved for internal use.
Public property Application Returns an Application object that represents the Microsoft Excel application. Read-only.
Public property Count Returns the number of objects in the collection. Read-only Integer.
Public property 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.
Public property Item Returns a single object from a collection.
Public property Parent Returns the parent object for the specified object. Read-only.

Top

Methods

  Name Description
Public method __OpenText Reserved for internal use.
Public method _Open Reserved for internal use.
Public method _OpenText
Public method _OpenXML Reserved for internal use.
Public method Add Creates a new workbook. The new workbook becomes the active workbook. Returns a Workbook object.
Public method CanCheckOut True if Microsoft Excel can check out a specified workbook from a server. Read/write Boolean.
Public method CheckOut Copies the specified workbook from a server to a local computer for editing.
Public method Close Closes the object.
Public method GetEnumerator() (Inherited from IEnumerable.)
Public method GetEnumerator()
Public method Open Opens a workbook.
Public method OpenDatabase Returns a Workbook object representing a database.
Public method OpenText Loads and parses a text file as a new workbook with a single sheet that contains the parsed text-file data.
Public method OpenXML Opens an XML data file. Returns a Workbook object.

Top

See Also

Reference

Workbooks Interface

Microsoft.Office.Interop.Excel Namespace