View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Youlden Chris Youlden is offline
external usenet poster
 
Posts: 5
Default 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