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.

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.

DataFeedConnection

Returns a DataFeedConnection object that contains the data and functionality needed to connect to data feeds. Read-only

Description

Returns or sets a brief description for a WorkbookConnection object. Read/write String.

InModel

Specifies whether or not the WorkbookConnection Object (Excel) has been added to the model. Boolean Read-only

ModelConnection

Returns an object that contains information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated Data Model. Read-only

ModelTables

Returns a ModelTables Object (Excel) object associated with the particular connection. Read-only

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.

RefreshWithRefreshAll

Determines if the connection should be refreshed when refresh all is executed. Boolean. Read/Write

TextConnection

Returns a TextConnection Object (Excel) object that contains the information on a query to a text file. Read-only

Type

Returns the workbook connection type. Read-only XlConnectionType.

WorksheetDataConnection

Returns an object that contains information for a connection from the PowerPivot Model to data within the workbook such as a range, named range, or table. Read-only

Show:
© 2014 Microsoft