ModelConnection Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Name

Description

ADOConnection

The ADO Connection Object is used to create an open connection to a data source. Enables addins, such as Powerview, to create a direct connection to the engine and hence the data model. ADOConnection object Read-only.

Application

Returns an Application object that represents the Microsoft Excel application. Read-only.

CalculatedMembers

Returns a CalculatedMembers object that represents the calculated members in the model connection.

CommandText

Returns or sets the command string for the specified data source. Variant Read/Write

CommandType

Returns or sets one of the XlCmdType Enumeration (Excel) constants. Read/Write

Creator

Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long.

Parent

Returns an Object that represents the parent object of the specified ModelConnection object. Read-only.

Show: