PDA

View Full Version : Run Code after Automatic Refresh



JVollmer
07-22-2009, 01:07 PM
I currently have an Excel Workbook that pulls data from an Access Database every 10 minutes (using Data -> Import External Data). What I am trying to do is run some code, that I have written, automatically after every refresh occurs. Currently I have not been able to find a way to do this, can anyone help?

nst1107
07-22-2009, 01:39 PM
The best I clue I can give is that the Worksheet_Change event is triggered every time it refreshes. You may be able to use Intersect and a conditional statement to exit out of the sub whenever you change other areas of your sheet provided you never change the cells that are getting refreshed.