Auto-run macro after auto-query refresh (Excel2000,sr1)

[Guest]

Hi,

Re: Excel 2000, SR-1, Auto-running Macros

I would like to know if it is possible to program Excel to automatically run
a macro after a Refresh Query event is automatically run? If so, can you
provide the VB command/s or other that will enable this process?

I am only a novice at VB, but decent with programming. I have searched, but
not yet found a solution.

 

[Tom Ogilvy]

http://support.microsoft.com/kb/182735/en-us
XL97: How to Use the Query Before and AfterRefresh Events

http://support.microsoft.com/kb/213187/en-us
XL2000: How to Use the Query BeforeRefresh and AfterRefresh Events

 

[Guest]

I plug my 6 in 1 card reader & writer into the USB and put the memory card
into the reader the light flashes as if to transfer the image but nothing.
What is my problem?

 

[Dave Peterson]

When I do this kind of thing, I have to open Windows Explorer and do the copy
manually.

Or choose an option from that dialog box that pops up when you insert a new USB
drive (but this can be turned off, too).

I plug my 6 in 1 card reader & writer into the USB and put the memory card
into the reader the light flashes as if to transfer the image but nothing.
What is my problem?

[/QUOTE]