Disclaimer: I’m not good at Excel VBA. That’s why I take advantage of ChatGPT to generate the code for me.
The requirements
Here are my requirements:
- When I hit the button, refresh the table called AgingTable in the Aging sheet
- The AgingTable is connected to a Power Query called the same name: AgingTable
- Since the AgingTable query is a big table and runs several transformation, it may take a while for the query to finish
- However, before proceeding to the next script in the VBA I want it to wait for the query to complete
Continue reading VBA code to refresh an Excel table generated by a power query