ListObject.QueryTable Property

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

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

Syntax

'Declaration
ReadOnly Property QueryTable As QueryTable
QueryTable QueryTable { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.QueryTable
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 Sub ListObject_QueryTable()
        Me.customerListObject.QueryTable.Refresh()
    End Sub
private void ListObject_QueryTable()
{
    this.customerListObject.QueryTable.Refresh();
}

.NET Framework Security

See Also

Reference

ListObject Interface

Microsoft.Office.Tools.Excel Namespace