Forum Discussion
10500438
Helper II
Helper IITrigger Macro after all the Power Queries have updated
I have a power pivot model that has 10 queries, I have it set to refresh all when the workbook is opened. I have an Model Change event to save the workbook. Then a save event that triggers a macro to...
AlB
Community Champion
Community ChampionHi 10500438
Perhaps this would be of help?
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
10500438Helper II
Helper III think I am trying to delay the vba from running until all the queries have updated.
I know I can use Application.Wait, but I was hoping there was a way to determine the updating sequence of the queries and then use the last query updated to kick off the vba.
Any thoughts?