Running a macro from an auto-refresh

C

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
 
G

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.
 
C

Chris Youlden

Gary''s Student said:
Use an OnTome event to run every 5 minutes as well, but set to run say 5
seconds after the query refresh.
Click to expand...

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

Chris
 
Top