Run Code after Automatic Refresh

[JVollmer]

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?

[venkat1926]

use event code "change" in worksheet event code

right click sheet tab and click view code and in the sheet code window
in the left arrow choose "worksheet"
in the right arrow choose "change"
from the drop down lists.

you write the code there.

this means whenever the target ( a particular cell in the sheet changes due to refresh) changes value due to refresh, the code will run. If a number of cells change due to refresh then make the last cell which changes as the target.

you have to some experiments with a dummy file.

[T-J]

What I am trying to do is run some code, that I have written, automatically after every refresh occurs.

See Visual Basic Help topic QueryTable Object Events

[JVollmer]

use event code "change" in worksheet event code

right click sheet tab and click view code and in the sheet code window
in the left arrow choose "worksheet"
in the right arrow choose "change"
from the drop down lists.

you write the code there.

this means whenever the target ( a particular cell in the sheet changes due to refresh) changes value due to refresh, the code will run. If a number of cells change due to refresh then make the last cell which changes as the target.

you have to some experiments with a dummy file.

Using a Change Event just causes an almost endless loop since part of the code that is running is formatting that data that was just brought in. This was the first thing I tried.

[JVollmer]

See Visual Basic Help topic QueryTable Object Events

QueryTable Object Events do not seem to be exisitant in Excel 2003, only 2007. Any other ideas?

[santanuKD]

This works fine guys...

[T-J]

QueryTable Object Events do not seem to be exisitant in Excel 2003, only 2007. Any other ideas?

Incorrect, they are available in 2003. Again, read the help topic.

[JVollmer]

Incorrect, they are available in 2003. Again, read the help topic.

I apologize, you are correct. I finally got it to work using the QueryTable Events. Thanks for your help T-J