Model Object Members (Excel)

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.

Methods

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.

Properties

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.