False if the column widths are not automatically adjusted with each refresh. PropertiesĪdjustColumnWidth true if the column widths are automatically adjusted for the best fit each time you refresh the specified query table. SaveAsODC - Saves the QueryTable cache source as a Microsoft Office Data Connection file. ResetTimer - Resets the refresh timer for the specified query table or PivotTable report to the last interval that you set by using the RefreshPeriod property. Refresh - Updates an external data range in a QueryTable object. Use the Refreshing property to determine whether a background query is currently in progress. Dim qrytbl As QueryTableįor Each qrytbl In Application.QueryTablesĬancelRefresh - Cancels all background queries for the specified query table. Here is an example of processing the QueryTable items in a collection. The following procedures can be used to set variables of type QueryTable: ListObject.QueryTable, QueryTables.Add, QueryTables.Item and Range.QueryTable. To use a QueryTable class variable it first needs to be instantiated, for example Dim qrytbl as QueryTable
The class QueryTable represents a worksheet table built from data returned from an external data source, such as a SQL server or a Microsoft Access database.
0 kommentar(er)
