Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Running Macros Automatically (2000)

    Hi again.

    I may have asked this before, but I don't remember.

    Is there a way to automatically run a simple cut and paste macro after an external data query is refreshed?

    -tmg

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Running Macros Automatically (2000)

    Are you referring to <post#=310740>post 310740</post#>?

    (I found this by clicking on the 'Poster' column heading in the Excel forum; this sorts posts by user name, descending. Moving to the next page a few times, I could quickly find all threads started by you this way.

  3. #3
    Star Lounger
    Join Date
    May 2003
    Posts
    69
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Running Macros Automatically (2000)

    Well, I solved that problem a different way. I couldn't get it to work the way I was told.

    I thought that a simple cut and paste macro may be able to be done some other way.

    -tmg

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Running Macros Automatically (2000)

    If you want it to run automatically after the query table refresh, you create a macro, and then have it called after the table updates as described in the thread Hans referenced.

    Or you create code to call the refresh, then when it is done, run the other code. This method does not need the afterrefresh event code, but it only runs if you do the refresh using your whole code. If you manually refresh, you will have to manually run the cut/paste method.

    Steve

Posting Permissions

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