If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Excel2016 VBA to pause until PowerQuery has updated

Thread starter KimC2504
Start date Oct 19, 2017
Tags

2nd excel pause query vba

KimC2504

Board Regular

Oct 19, 2017

Code:

Sub PowerQueryRefresh()

    ActiveWorkbook.Connections("Query - Actuals").Refresh
    ActiveWorkbook.Connections("Query - SFDC").Refresh
    ActiveWorkbook.Connections("Query - PW Most Likely").Refresh

    End Sub

Hi All,
I have just upgraded to Excel 2016 and I am wondering if excel 2016 can know get VBA to pause until first query is completed prior to proceeding to 2nd query and then the 3rd query. I don't want to refresh every query in the workbook at once, just the queries identified. I could never get this to work in excel 2013 so I am hopeful...