| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
QueryTable.WorkbookConnection property (Excel) |
vbaxl10.chm518138 |
|
|
d35d7bb6-5036-1dd9-46ff-e96127d3db09 |
05/03/2019 |
medium |
Returns the WorkbookConnection object that the query table uses. Read-only.
expression.WorkbookConnection
expression A variable that represents a QueryTable object.
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 WorkbookConnection property applies only to QueryTable objects.
[!includeSupport and feedback]