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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |