QueryTable Events

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.