I'm linking to an external data file and pulling the results into a table. The table is the special table type that was introduced in Excel 2007.
I need a way to run some vba code right before the data is refreshed i.e. updated.
Is there there an event I can use to trigger vba?