Office development

Model Object Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

Stores references to workbook connections and information about the tables and relationships contained within the Data Model.

Name

Description

AddConnection

Adds a new Workbook Connection to the model with the same properties as the one supplied as an argument.

CreateModelWorkbookConnection

Returns a WorkbookConnection Object (Excel) object of type ModelConnection Object (Excel).

Initialize

Initializes the Workbook’s Data Model. This is called by default the first time the model is used.

Refresh

Refreshes all data sources associated with the model, fully reprocesses the model and updates all Excel data features associated with the Model.

Name

Description

Application

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

Creator

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

DataModelConnection

Returns the model workbook connection object from the workbook connections collection which connects to the model.

ModelRelationships

Returns a collection of relationships between Data Model tables. Read-only

ModelTables

Returns a collection of tables inside the Data Model. Read-only

Name

Returns a String value representing the name of the Model object. Read-only

Parent

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

ModelFormatBoolean

Returns a ModelFormatBoolean object that represents formatting of type true/false in the data model. Read-only .

ModelFormatCurrency

Returns a ModelFormatCurrency object that represents formatting of type currency in the data model. Read-only .

ModelFormatDate

Returns a ModelFormatDate object that represents formatting of type date in the data model. Read-only .

ModelFormatDecimalNumber

Returns a ModelFormatDecimalNumber object that represents formatting of type decimal number in the data model. Read-only.

ModelFormatGeneral

Returns a ModelFormatGeneral object that represents formatting of type general in the data model. Read-only.

ModelFormatPercentageNumber

Returns a ModelFormatPercentageNumber object that represents formatting of type percentage number in the data model. Read-only .

ModelFormatScientificNumber

Returns a ModelFormatScientificNumber object that represents formatting of type scientific number in the data model. Read-only.

ModelFormatWholeNumber

Returns a ModelFormatWholeNumber object that represents formatting of type whole number in the data model. Read-only .

ModelMeasures

Returns a ModelMeasures Object (Excel) object that represents the collection of model measures in the data model. Read-only.

Show:
© 2016 Microsoft