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


    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!