Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power Query NOT Refreshing on Refresh All VBA

I have built a large report using purely Excel with Power Query. A lot of steps are involved in PQ and later loaded in Excel sheet the final report. I tried to automate it but Refreshing is not worki...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    CNENFRNL I will have a check with your code. Just a quick question, I saw your VBA code, could you clafify what I wrote in purple below?

     

    Public Sub Workbook_Open()
    Application.ScreenUpdating = False
    ' ActiveWorkbook.RefreshAll

    With ActiveWorkbook.Connections("Query - Query1")
    .Refresh
    .OLEDBConnection.BackgroundQuery = bBackground //bBackground or Background only?
    End With

    ThisWorkbook.Save

    ' Application.Quit
    End Sub