_QueryTable.WorkbookConnection Property
Returns the WorkbookConnection object that the query table uses. Read-only.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property WorkbookConnection As WorkbookConnection
Get
'Usage
Dim instance As _QueryTable
Dim value As WorkbookConnection
value = instance.WorkbookConnection
WorkbookConnection WorkbookConnection { get; }
Property Value
Type: Microsoft.Office.Interop.Excel.WorkbookConnection
WorkbookConnection
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.