WorkbookConnection Members (Excel)

A connection is a set of information needed to obtain data from an external data source other than an Microsoft Office Excel 2007 workbook.

Methods

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

Name	Description
Application	When used without an object qualifier, this property returns an Application object that represents the Microsoft 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 Long.
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.