ModelChanges Properties (Excel)

GitHub-Mark-64px

Contribute to this content

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

Name

Description

Application

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

ColumnsAdded

Returns a ModelColumnNames Object (Excel) collection of ModelColumnName Object (Excel) objects which represent all columns added as part of a model operation. Read-only.

ColumnsChanged

Returns a ModelColumnChanges Object (Excel) collection of ModelColumnChange Object (Excel) objects which represent table names and column names of all table columns for which the data type was changed (might add more types of changes here in the future) as part of a model operation. Read-only.

ColumnsDeleted

Returns a ModelColumnNames Object (Excel) collection of ModelColumnName Object (Excel) objects which represent all columns which were deleted as part of a model operation. Read-only.

Creator

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

MeasuresAdded

Returns a ModelMeasureNames Object (Excel) collection of ModelMeasureName Object (Excel) objects which represent all measures which were added as part of a model operation. Read-only.

Parent

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

RelationshipChange

When True, one or more relationships in the model were changed (added, deleted or modified) as part of a model operation. When False, no relationships were changed during the operation. Boolean Read-only.

Source

TableNamesChanged

Returns a ModelTableNameChanges Object (Excel) collection of ModelTableNameChange Object (Excel) objects representing old and new names of all tables which were renamed in the model as part of a model operation. Read-only.

TablesAdded

Returns a ModelTableNames Object (Excel) collection of table names as strings representing all tables which were added to the model as part of a model operation. Read-only.

TablesDeleted

Returns a ModelTableNames Object (Excel) collection of table names as strings representing all tables which were deleted from the model as part of a model operation. Read-only.

TablesModified

Returns a ModelTableNames Object (Excel) collection of table names as strings representing all tables which were refreshed or recalculated as part of a model operation. Read-only.

UnknownChange

True when a non-specified change was made to the model as part of a model transaction. Boolean Read-only

Show: