Skip to content

Latest commit

 

History

History
36 lines (21 loc) · 1.19 KB

Excel.QueryTable.RobustConnect.md

File metadata and controls

36 lines (21 loc) · 1.19 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
QueryTable.RobustConnect property (Excel)
vbaxl10.chm518133
vbaxl10.chm518133
Excel.QueryTable.RobustConnect
ad180446-82d7-7b5b-59a2-b0de299ae934
05/03/2019
medium

QueryTable.RobustConnect property (Excel)

Returns or sets how the query table connects to its data source. Read/write XlRobustConnect.

Syntax

expression.RobustConnect

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 RobustConnect property.

[!includeSupport and feedback]