QueryTable AfterRefresh Event
This event occurs after a query is completed
or canceled.
QueryTable BeforeRefresh Event
This event occurs before the query tables
refreshes. This event can occur by calling the refresh method of the query
table or when the workbook that contains the query table is opened.