where do i place the code ?
 

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.

where do i place the code ?
 

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


--
Regards,
Tom Ogilvy


"Asha" wrote in message
...
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.

where do i place the code ?
 

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

"Tom Ogilvy" wrote:

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


--
Regards,
Tom Ogilvy


"Asha" wrote in message
...
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.