QueryTable.WorkbookConnection Property
| Excel Developer Reference |
Returns the WorkbookConnection object that the query table uses. Read-only.
Version Information
Version Added: Excel 2007
Syntax
expression.WorkbookConnection
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 WorkbookConnection property applies only to QueryTable objects.
See Also