_QueryTable.WorkbookConnection Property

Definition

Returns the WorkbookConnection object that the query table uses. Read-only.

public:
 property Microsoft::Office::Interop::Excel::WorkbookConnection ^ WorkbookConnection { Microsoft::Office::Interop::Excel::WorkbookConnection ^ get(); };
public Microsoft.Office.Interop.Excel.WorkbookConnection WorkbookConnection { get; }
Public ReadOnly Property WorkbookConnection As WorkbookConnection

Property Value

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.

Applies to