QueryTable.ListObject property (Excel)

Returns a ListObject object for the QueryTable object. Read-only ListObject object.

Syntax

expression. ListObject

expression A variable that represents a QueryTable object.

Remarks

If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.

If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable , while all other external data can be imported as either a ListObject or a QueryTable .

The ListObject property applies only to ListObject objects.

See also

QueryTable Object