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