How to check if one query from Power Query was refreshed

[jaryszek]

Hi,

i am still fighting with PQ and the issue is that refresh all based on dynamic parameter as path to external workbook is not working via VBA.
What i have to do is to catch somehow that 1 table was refreshed.

And after that trigger another macro in the loop. Otherwise Excel stops after refreshing one query.

Do yoi have any idea how tyo catch this event?

Jacek

[jaryszek]

I am trying with class "Class1" with code:

Option Explicit
Private WithEvents table As Excel.QueryTable
Private currentIndex As Long
Private tables As Variant

Private Sub table_AfterRefresh(ByVal Success As Boolean)
    Debug.Print table.WorkbookConnection.Name & " refreshed. (success: " & Success & ")"
    currentIndex = currentIndex + 1
    If Success And currentIndex <= UBound(tables) Then
        Set table = tables(currentIndex)
        table.Refresh
    End If
End Sub

but this is not triggering after refreshing table...

Best,
Jacek

[jaryszek]

I am stop using PQ with dynamic reference to external workbook. It is causing so many issues...

I am choosing standard way - so VBA and copying tables from external workbook to internal.
No wortg go with dynamic parameter and PQ...

JAcek