Forum Discussion
VBA Wait for Query Refresh
Hi Excel Community, I am having issues with a detailed macro that requires multiple queries to be refreshed several times throughout the running of the VBA code to allow the user to visualise updat...
Impossible to answer without seeing at least some relevant bits of your code I'm afraid.
You don't mention what type of query you are talking about, e.g. is this through the legacy query wizard, PowerQuery, VBA, some other connection? A QueryTable object has a Refreshing property which should tell you if it is -well- refreshing.
You don't mention what type of query you are talking about, e.g. is this through the legacy query wizard, PowerQuery, VBA, some other connection? A QueryTable object has a Refreshing property which should tell you if it is -well- refreshing.