Share via


WorkbookConnection Members

Include Protected Members
Include Inherited Members

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

The WorkbookConnection type exposes the following members.

Properties

  Name Description
Public property _Default
Public property 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.
Public property Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Integer.
Public property Description Returns or sets a brief description for a WorkbookConnection object. Read/write String.
Public property Name Returns or sets the name of the workbook connection object. Read/write String.
Public property ODBCConnection Retuns the ODBC Connection details for the specified WorkbookConnection object. Read-only ODBCConnection.
Public property OLEDBConnection Retuns the OLEDB Connection details for the specified WorkbookConnection object. Read-only OLEDBConnection.
Public property Parent Returns the parent object for the specified object. Read-only.
Public property Ranges Returns the range of object for the specified WorkbookConnection object. Read-only Ranges.
Public property Type Returns the workbook connection type. Read-only XlConnectionType.

Top

Methods

  Name Description
Public method Delete Deletes a workbook connection.
Public method Refresh Refreshes a workbook connection.

Top

See Also

Reference

WorkbookConnection Interface

Microsoft.Office.Interop.Excel Namespace