ModelTable Members (Excel)

Office 2013

Represent a table in the Data Model.

Name

Description

Refresh

Refreshes the model table source connections.

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

Show:
© 2015 Microsoft