Event after data refresh?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to the VBA side of Excel. Is there an Event built in for something
like AfterDataRefresh, or AfterSQL call or something? I still haven't
figured out the best way to find everything available.

thx - Russ
 
I still haven't figured out the best way to find everything available.

Using the Object Browser in the VBE is one way. Pick your object in the
left panel (Application, Workbook, Worksheet...) and anything in the right
panel with a lightning bolt icon is an event.


--
Jim
| I'm new to the VBA side of Excel. Is there an Event built in for
something
| like AfterDataRefresh, or AfterSQL call or something? I still haven't
| figured out the best way to find everything available.
|
| thx - Russ
 
Thanks Jim. That was a good exercise. I thought method was under
application, workbook or worksheet. I couldn't find anything there so I
searched and eventually found the BeforeRefresh method under the QueryTable
object. So if I'm writing VBA code using the Query Table object does it
matter where I put the code - ThisWorkbook, Sheet1, or Module?

thanks
 
ThisWorkbook, Sheet1, or Module?

None of the above. You have to use a class module. This may help:

http://support.microsoft.com/kb/213187

--
Jim
| Thanks Jim. That was a good exercise. I thought method was under
| application, workbook or worksheet. I couldn't find anything there so I
| searched and eventually found the BeforeRefresh method under the
QueryTable
| object. So if I'm writing VBA code using the Query Table object does it
| matter where I put the code - ThisWorkbook, Sheet1, or Module?
|
| thanks
|
| "Jim Rech" wrote:
|
| > >> I still haven't figured out the best way to find everything
available.
| >
| > Using the Object Browser in the VBE is one way. Pick your object in the
| > left panel (Application, Workbook, Worksheet...) and anything in the
right
| > panel with a lightning bolt icon is an event.
| >
| >
| > --
| > Jim
| > | > | I'm new to the VBA side of Excel. Is there an Event built in for
| > something
| > | like AfterDataRefresh, or AfterSQL call or something? I still haven't
| > | figured out the best way to find everything available.
| > |
| > | thx - Russ
| >
| >
| >
 
Ahh. I'm reading Excel VBA Programming for Dummies and I'm about half way
through. There hasn't been any mention yet of classes, but I see how it can
work. Thanks much.
 
Back
Top