ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Auto-run macro after auto-query refresh (Excel2000,sr1) (https://www.excelbanter.com/excel-programming/360888-auto-run-macro-after-auto-query-refresh-excel2000-sr1.html)

Bill Cufflin

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

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.
--
Thanks for your input!

Bill

Tom Ogilvy

Auto-run macro after auto-query refresh (Excel2000,sr1)
 
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

--
regards,
Tom Ogilvy




"Bill Cufflin" wrote in message
...
Hi,

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.
--
Thanks for your input!

Bill




dry4

auto run
 
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?
--
grateful












Dave Peterson

auto run
 
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).



dry4 wrote:

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?
--
grateful



--

Dave Peterson


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com