Running a macro from an auto-refresh

[Chris Youlden]

I have a worksheet that imports data using a data query from an Access
database.

The external data range properties are set to auto refresh the data
every 5 minutes.

Is there a way for the data refresh to automatically run a macro every
time it occurs?

TIA

 

[Gary''s Student]

Use an OnTome event to run every 5 minutes as well, but set to run say 5
seconds after the query refresh.

 

[Chris Youlden]

Use an OnTome event to run every 5 minutes as well, but set to run say 5
seconds after the query refresh.

Excellent - thanks. I'll give it a go.

Chris