Skip to content

Latest commit

 

History

History
37 lines (21 loc) · 1.09 KB

Excel.QueryTable.ListObject.md

File metadata and controls

37 lines (21 loc) · 1.09 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
QueryTable.ListObject property (Excel)
vbaxl10.chm518136
vbaxl10.chm518136
Excel.QueryTable.ListObject
a302d0ac-7084-ba20-4e01-fe5e93bac307
05/03/2019
medium

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 by 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 by 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.

[!includeSupport and feedback]