Running a macro from an auto-refresh

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Youlden - 06 Oct 2007 19:58 GMT

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

Signature

Chris

Reply to this Message

Gary''s Student - 06 Oct 2007 23:18 GMT

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

Signature

Gary''s Student - gsnu2007

> I have a worksheet that imports data using a data query from an Access
> database.
[quoted text clipped - 6 lines]
>
> TIA

Reply to this Message

Chris Youlden - 07 Oct 2007 16:22 GMT

> 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

Reply to this Message