+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Bill Cufflin
    Guest

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

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

    Bill

  2. #2
    Tom Ogilvy
    Guest

    Re: 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" <BillCufflin@discussions.microsoft.com> wrote in message
    news:EE0CA68D-2EEC-4299-9600-677B59EC4FDC@microsoft.com...
    > 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.
    > --
    > Thanks for your input!
    >
    > Bill




  3. #3
    dry4
    Guest

    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. #4
    Dave Peterson
    Guest

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1