ModelRelationships Members (Excel)

GitHub-Mark-64px

Contribute to this content

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

This collection contains all relationships currently between data tables in the data model of Excel 2013.

Name

Description

Add

Adds a new relationship to the model.

Item

Returns a single object from the ModelRelationships Object (Excel) object.

DetectRelationships

Detects model relationships in the specified PivotTable.

Name

Description

Application

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

Count

Returns a Long value that represents the number of a ModelRelationship Object (Excel) objects in a ModelRelationships Object (Excel) object. Read-only.

Creator

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

Parent

Returns an Object that represents the parent object of the specified ModelRelationships Object (Excel) object. Read-only.

Show: