QueryTable Events (Excel)
This object has the following events:
Occurs after a query is completed or canceled.
Occurs before any refreshes of the query table. This includes refreshes resulting from calling the Refresh method, from the user's actions in the product, and from opening the workbook containing the query table.