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 | |
|---|---|---|
.gif "Public property") |
_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 | |
|---|---|---|
.gif "Public method") |
Delete | Deletes a workbook connection. |
|
Refresh | Refreshes a workbook connection. |
Top