ModelConnection Members (Excel)

Office 2013

Published: July 16, 2012

Contain information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated data model.

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

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.

Community Additions

ADD
Show:
© 2014 Microsoft