-
Run Code after Automatic Refresh
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?
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules