Running a macro from an auto-refresh
 

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

--

Chris

Running a macro from an auto-refresh
 

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


"Chris Youlden" wrote:

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

--

Chris

Running a macro from an auto-refresh
 

Gary''s Student wrote:
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