WorkbookConnection Object Members

  • Article
Excel Developer Reference

A connection is a set of information needed to obtain data from an external data source other than an 1st_Excel12 workbook.

Methods

  Name Description
Bb225768.methods(en-us,office.12).gif Delete Deletes a workbook connection.
Bb225768.methods(en-us,office.12).gif Refresh Refreshes a workbook connection.

Properties

  Name Description
Bb225768.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Bb225768.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb225768.properties(en-us,office.12).gif Description Returns or sets a brief description for a WorkbookConnection object. Read/write String.
Bb225768.properties(en-us,office.12).gif Name Returns or sets the name of the workbook connection object. Read/write String.
Bb225768.properties(en-us,office.12).gif ODBCConnection Retuns the ODBC Connection details for the specified WorkbookConnection object. Read-only ODBCConnection.
Bb225768.properties(en-us,office.12).gif OLEDBConnection Retuns the OLEDB Connection details for the specified WorkbookConnection object. Read-only OLEDBConnection.
Bb225768.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb225768.properties(en-us,office.12).gif Ranges Returns the range of object for the specified WorkbookConnection object. Read-only Ranges.
Bb225768.properties(en-us,office.12).gif Type Returns the workbook connection type. Read-only XlConnectionType.