Consulting

Results 1 to 2 of 2

Thread: Run Code after Automatic Refresh

  1. #1
    VBAX Newbie
    Joined
    Jul 2009
    Posts
    1
    Location

    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?

  2. #2
    VBAX Tutor nst1107's Avatar
    Joined
    Nov 2008
    Location
    Monticello
    Posts
    245
    Location
    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
  •