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
Bookmarks