Class ModelConnection (Excel VBA)

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


The ADOConnection adoconnection is used to create an open connection to a data source. Enables add-ins, such as Powerview, to create a direct connection to the engine and hence the data model. Read-only ADOConnection adoconnection.


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


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

The command text is either a table name (of a model table) or a DAX expression evaluating to a table.


Returns or sets one of the XlCmdType enumeration constants.

Possible Values are xlCmdCube - Contains a cube name for an OLAP data source, xlCmdDAX - Contains a Data Analysis Expressions (DAX) formula, xlCmdDefault - Contains command text that the OLE DB provider understands, xlCmdExcel - Contains an Excel formula, xlCmdList - Contains a pointer to list data, xlCmdSql - Contains an SQL statement, xlCmdTable - Contains a table name for accessing OLE DB data sources, xlCmdTableCollection - Contains the name of a table collection.

For a ModelConnection object, this type will be set to either xlCmdTable or xlCmdDAX. The isolated connection ThisWorkbookDataModel to the data model will be of type xlCmdCube.


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