WorkbookConnection Properties (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Properties
Name |
Description |
---|---|
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. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
Returns a DataFeedConnection object that contains the data and functionality needed to connect to data feeds. Read-only |
|
Returns or sets a brief description for a WorkbookConnection object. Read/write String. |
|
Specifies whether or not the WorkbookConnection Object (Excel) has been added to the model. Boolean Read-only |
|
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 |
|
Returns a ModelTables Object (Excel) object associated with the particular connection. Read-only |
|
Returns or sets the name of the workbook connection object. Read/write String. |
|
Retuns the ODBC Connection details for the specified WorkbookConnection object. Read-only ODBCConnection. |
|
Retuns the OLEDB Connection details for the specified WorkbookConnection object. Read-only OLEDBConnection. |
|
Returns the parent object for the specified object. Read-only. |
|
Returns the range of object for the specified WorkbookConnection object. Read-only Ranges. |
|
Determines if the connection should be refreshed when refresh all is executed. Boolean. Read/Write |
|
Returns a TextConnection Object (Excel) object that contains the information on a query to a text file. Read-only |
|
Returns the workbook connection type. Read-only XlConnectionType. |
|
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 |