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
|