ListObject Property
As it applies to the Range object.
A Range object property that returns a ListObject object if there is any list object intersecting the specified range. Read-Only.
expression .ListObject
expression Required. An expression that returns a Range object.
Remarks
You can use the ListObject property to find out if there is an XML list in a range. This property parallels the PivotTable and QueryTable properties of the Range object in Microsoft Excel. If more than one ListObject object intersects the specified range, the Spreadsheet component will arbitrarily pick one to return.
As it applies to the Workbook object.
Returns a ListObject object.
expression .ListObject (EntryID)
expression Required. An expression that returns a Workbook object.
EntryID Required String. The value of the ID attribute of an MapInfo/Map/Entry in an XML Spreadsheet.
Remarks
Returns a ListObject object for a particular EntryID from an XML Spreadsheet mapping in the <MapInfo> element at MapInfo/Map/Entry.
The XML fragment where the details appear in the XML Spreadsheet file looks something like the following:
<x2:MapInfo xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml">
<x2:Map x2:ID="Cust_MapId">
<x2:Entry x2:ID="example_id" x2:Type="table">
...
</x2:Entry>
</x2:Map>
</x2:MapInfo>
Example
As it applies to the Range object.The example below returns the XML list in a the specified range.
ActiveSheet.Range("A1:G9").ListObject
The example below looks for a specific ListObject object in the active workbook.
Dim objList
Set objList = Spreadsheet1.ActiveWorkbook.ListObject("example_id")