Wait until Refresh is done

Hi, I use ListObject.QueryTable property to get external data. Driver ODBC, BackgroundQuery = False.

I have some lines of code after QueryTable.Refresh, that are executed even the Query has not stopped running yet.
I'd like them to wait until the Refresh is done.

I tried to switch BackgroundQuery to True, Application.Wait, also a DoEvents method, but these don't do the trick.

Try this

Application.ScreenUpdating = False

If it works make sure to re-enable it when done.

Originally Posted by DouglasLL

Try this

Application.ScreenUpdating = False

If it works make sure to re-enable it when done.

this work for me.. thx

yw - it's really good for large sheets, graphics, and conditional formatting that takes a long time.

Thanks guys for your replies. Actually, neither

Please Login or Register  to view this content.

nor

Please Login or Register  to view this content.

do the desired effect.
Let's say I have a query that pulls data from external database. After the Refresh command I have line that activates different sheet, another line that let's say fires a Message Box. Both these lines proceed even the comment "Refreshing" is still indicated on status bar/

I have recently tried:

Please Login or Register  to view this content.

and it looks promising, meaning it takes longer to fire that msgbox but Refreshing process is not displayed on status bar anymore. Can someone please clarify me this application property?
The excel help system is not very explanatory to my opinion.

Also posted at http://www.ozgrid.com/forum/showthread.php?t=198021

Thanks for my missing reference grimes.
Any idea on explaining the above Application method ?