Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Workbooks Methods 

  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.

Community Additions

© 2015 Microsoft