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