ListObject.QueryTable Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets the QueryTable that provides a link for the ListObject control to the list server.
public:
property Microsoft::Office::Interop::Excel::QueryTable ^ QueryTable { Microsoft::Office::Interop::Excel::QueryTable ^ get(); };public Microsoft.Office.Interop.Excel.QueryTable QueryTable { get; }member this.QueryTable : Microsoft.Office.Interop.Excel.QueryTablePublic ReadOnly Property QueryTable As QueryTableProperty 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