| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where 2 place the code? (Worksheet Codes Vs. Modules) | Excel Discussion (Misc queries) | |||
| Wherre best to place code | New Users to Excel | |||
| Where to place Code question | Excel Programming | |||
| Place space in postal code | Excel Programming | |||
| Place code in a new workbook with a macro. | Excel Programming | |||
Hybrid Mode
