How can I run a macro after a data source refresh is completed?

[vbaNumpty]

Tried looking around online, but I haven't come across anything that seems to do what I am trying to achieve.

I would like for a macro to be run/called after a data connection has been refreshed whether it is automatic or manually done.

I am also looking for the connection to refresh upon opening and then have my workbook open code take place after the new values are imported.

 

[vbaNumpty]

My data is in a table, and if I could tie the macro to a change event on a table refresh that would likely suit my needs. But I can only find update events for pivot tables and not regular tables.