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 still runs.
    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.

    Re: Wait until Refresh is done


    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    *

    Re: Wait until Refresh is done


    Hi, does someone know what

    Code
    Application.CalculateUntilAsyncQueriesDone

    does exactly ?
    The Microsoft help only says: " Runs all pending queries to OLEDB and OLAP data sources. "
    At first sight this works to solve my issue, however I'm not certain about it.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login