Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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











  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to open after auto refresh(Query) Irmann Excel Discussion (Misc queries) 0 January 8th 08 06:33 AM
Web Query Auto Refresh sjgillum Excel Worksheet Functions 2 December 6th 07 12:23 PM
How do you avoid window that prompts to enable auto query refresh Peter_EZEM Excel Discussion (Misc queries) 3 January 23rd 06 07:17 PM
auto Refresh MS Query SQL Server Souris Excel Programming 3 August 11th 05 09:52 PM
How do I get a web query to auto-refresh before a pivot table aut. Conniemm Excel Discussion (Misc queries) 0 December 8th 04 06:49 PM


All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"