Skip to content

Latest commit

 

History

History
37 lines (21 loc) · 1.1 KB

Excel.QueryTable.Parent.md

File metadata and controls

37 lines (21 loc) · 1.1 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
QueryTable.Parent property (Excel)
vbaxl10.chm517075
vbaxl10.chm517075
Excel.QueryTable.Parent
6cf47be7-5e4a-31d0-0c11-e9506c052ecf
05/03/2019
medium

QueryTable.Parent property (Excel)

Returns the parent object for the specified object. Read-only.

Syntax

expression.Parent

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.

Use the QueryTable property of the ListObject to access the Parent property.

[!includeSupport and feedback]