Thread: where do i place the code ?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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.



Reply With QuoteReply With Quote