where do i place the code ?

[Guest]

Actually i have an excel sheet with a query, created through sql query
builder, whenever i select the option "refresh" in "external data range"
properties dialog box, i
want to execute a particular VB code. To do so in VBA under which
method/event i have to define my code.
Hope this explains the scenario. Plz suggest.

 

[Tom Ogilvy]

http://support.microsoft.com/support/kb/articles/q182/7/35.asp
XL97: How to Use the Query Before and AfterRefresh Events

 

[Guest]

Thanks a lot Tom Ogilvy, the link u specified was very helpful to solve my
problem.