Name
querytable.BackgroundQuery [= setting]
Synopsis
True refreshes data in the query table asynchronously; False refreshes data synchronously. Default is True.
The BeforeRefresh and AfterRefresh events occur whether the query is refreshed synchronously or asynchronously. When synchronous, both events occur before the Refresh method completes. When asynchronous, only the BeforeRefresh event occurs before the Refresh method completes; then program flow continues.
BackgroundQuery has little discernible effect on text queries.
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
