Enable Auto Refresh - Wait for refresh to sinish before running a macro

**tomlancaster** · 02-21-2011, 07:27 AM

I have an excel workbook which has several sheets that each import external data on file open. These data sources are already defined in the workbook and do not use VBA to import the data.

I would like to run some VBA code after the external data has been refreshed but I do not know how to. Can anyone help?

**Colin Legg** · 02-21-2011, 08:07 AM

Hi,

Is the data being pulled into a query table or a pivot table?

**tomlancaster** · 02-21-2011, 11:43 AM

Hi Colin, it is a Query Table.

I have used 'Data > Import External Data > Import Data' to get information from another workbook.

**Colin Legg** · 02-21-2011, 11:52 AM

Hi Tom,

Query tables have an AfterRefresh() event handler which you can use to call your macro. Here's a primer to get you started but if it doesn't make sense to you then you're welcome to attach a sample workbook and I (or someone else) will be happy to add the relevant code for you.