ModelConnection object (Excel)

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

Remarks

Use for all PivotTables connected to the model. The ModelConnection object is a new "special" workbook connection that always exists (and cannot be deleted) in workbooks that have a data model. It's created when the model is first created in a workbook. All the properties of this workbook connection are read-only. Its name is Workbook Data Model.

Properties

• ADOConnection
• Application
• CalculatedMembers
• CommandText
• CommandType
• Creator
• Parent

See also

• Excel Object Model Reference

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.