VBA abilty to refresh a Power Query Group (a.k.a. folder of queries) using a single script line
We need a VBA solution to allow a module/macro to refresh a Power Query Group by name. This solution would allow a single line of VBA code to refrence the Power Quer Group (folder) Name and refresh all queries within that folder.
It could be something as clean as:
ThisWorkbook.Connections.Group("My Folder of Queries").Refresh
Jerry Norbury commented
Also a way to know when the queries have completed...