QueryTable.BackgroundQuery Property
| Excel Developer Reference |
True if queries for the query table are performed asynchronously (in the background). Read/write Boolean.
Syntax
expression.BackgroundQuery
expression A variable that represents a QueryTable object.
Remarks
For OLAP data sources, this property is read-only and always returns False.
If you import data using the user interface, data from a Web query or a text query is imported as a QueryTable object, while all other external data is imported as a ListObject object.
If you import data using the object model, data from a Web query or a text query must be imported as a QueryTable, while all other external data can be imported as either a ListObject or a QueryTable.
You can use the QueryTable property of the ListObject to access the BackgroundQuery property.
See Also