Waiting for Workbook to Refresh Before Executing Next Line

[Statto]

I have a table that is using an ODBC data connection to update. I've created a button that allows the user to refresh this query, but I'm wondering how I can amend the code below so that my Excel workbook finishes refreshing before executing the next line of code — in this case it's to run another macro. I've tried various things including using Do While, but that does not work.

Please Login or Register  to view this content.

[saravnepali]

Use application.wait function

This will make the macro pause for approximately 10 seconds:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Statto]

Thanks, that works. The only thing is that it is based on a timer, so if the workbook hasn't refreshed in time, then the other macro will run — and this could lead to issues.

Is there a way to explicitly move on to the next part of the code only when the workbook has refreshed — no matter how long it takes.

[Rick Rothstein]

Does adding the indicated line of code work for you...

Please Login or Register  to view this content.

[Statto]

That does work, but only when I disable 'Enable background refresh' in the query's properties window. Thanks.

[Rick Rothstein]

That does work, but only when I disable 'Enable background refresh' in the query's properties window. Thanks.

I do not work with Queries, so using DoEvents was a guess given what it is supposed to do. Do you consider your question resolved? If so, please mark the thread SOLVED. If not, then another guess on my part... can you turn background refresh off just before the DoEvents and then turn them back on immediately afterwards?