ListObject.QueryTable Property

Definition

Gets the QueryTable that provides a link for the ListObject control to the list server.

public Microsoft.Office.Interop.Excel.QueryTable QueryTable { get; }

Property Value

The QueryTable that provides a link for the ListObject control to the list server.

Examples

The following code example uses the QueryTable property to refresh the query table that intersects a ListObject. This code example assumes that the current worksheet contains a ListObject named customerListObject that is intersected by a query table.

This example is for a document-level customization.

private void ListObject_QueryTable()
{
    this.customerListObject.QueryTable.Refresh();
}
Private Sub ListObject_QueryTable()
    Me.customerListObject.QueryTable.Refresh()
End Sub

Applies to