Forum Discussion
Wait until query is refreshed to run the next macro
Hi! I am trying to create a macro, but I need to wait until query is refreshed before doing the copy to paste in the workbook Sub OpenAnyFile() VBA.Shell "Explorer.exe C:\Users\vjrdcx\Aptiv\Apti...
You can set the queries in question to be synchronous.
Sorry what do you mean??
- There is a checkbox in the query properties that either allows or disallows the query to run in the background. Make sure it disallows it.
- But the thinks is that I don't have a code to wait until query is refreshed in OTHER workbook and then come back to the code workbook and continue the macro, how can I do it?
As long as the queries are set up to be synchronous, the VBA code does not matter as it will wait for the refresh to finish before proceeding.