ModelTable Members (Excel)

Article
05/23/2016

GitHub-Mark-64px

Contribute to this content

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

Represent a table in the Data Model.

Methods

Name	Description
Refresh	Refreshes the model table source connections.

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.
ModelTableColumns	Collection of ModelTableColumns Object (Excel) that make up the ModelTable. Read-only
Name	Returns a String value that represents the name of the object.
Parent	Returns an Object that represents the parent object of the specified ModelTable Object (Excel) object. Read-only.
RecordCount	Returns the total row count for the model table. Integer Read-only
SourceName	Name of the data source for the table. If the table has no data source, the call will generate a run-time error. String Read-only
SourceWorkbookConnection	Returns the Workbook Connection from which the model table originated. Read-only