I am using Power Query to retrieve data from an OLE DB database. The data from that Power Query 'PLN_Planning' needs to be processed after completion.

The query runs when the workbook is opened and, while the workbook is open, the query refreshed every 60 minutes.

Where do I code the macro (or macro's) that updates another Excel sheet within my workbook?
This macro has to run when the workbook is opened as well as after the query completes every 60 minutes.

Any help as well as examples would be greatly appreciated.

Ron