VBA MsgBox AFTER Background Query Completion

Newbie22 — Tue, 29 Aug 2023 11:28:34 GMT

Hi!

Is it possible to create a message box that will show if the refreshing/loading of Queries are completed?

Right now, I'm just looking at the bottom part of my Excel to know if it's still loading. I'd like to know if I can create a message box that will pop up once loading is done.

Here's my VBA code:

Sub RefreshAll()
'
' RefreshAll Macro
'
' Keyboard Shortcut: Ctrl+Shift+R
'
ActiveWorkbook.RefreshAll

End Sub

Re: VBA MsgBox AFTER Background Query Completion

Martin_D — Tue, 29 Aug 2023 16:30:48 GMT

Hi Newbie22 ,

you have 2 options to achieve this:

f you don't want to continue working in Excel while the refresh is ongoing, then you can turn off background refresh for each query and so the next line of code after RefreshAll(), which could be a MsgBox, will only execute after refresh is done.
If you want to continue working in Excel while RefreshAll() is executing in the background, then you can implement an AfterRefresh event handler for each query. Once refresh has finished for all refreshes, e.g. count how many AfterRefresh Events already occured, then finally show the message box. Example see here: http://www.vbaexpress.com/forum/showthread.php?30743-DoEvents-ActiveWorkbook-RefreshAll-Run-second-part-of-Macro-Once-Complete&s=dedbae73809c7fdb006a4cc805dba9e7&p=206543&viewfull=1#post206543

Martin

topic VBA MsgBox AFTER Background Query Completion in Developer

VBA MsgBox AFTER Background Query Completion

Re: VBA MsgBox AFTER Background Query Completion