want to auto-run a macro every 5 minutes but not lock up com
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: want to auto-run a macro every 5 minutes but not lock up com

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    it seems simple enough, but I can't seem to locate any info on this. I want to run a
    macro, say "foo", every 5 minutes. if the
    macro is not running, I would like to be able
    to shrink excel, work on the spreadsheet, basically do anything I want. Any Ideas?

    Thanks in Advance,

    Leslie

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    There may be an easier way (possibly using DoEvents) but I would say that this is easily done by making a quick Visual Basic exe that controls Excel.

    You can link to the open workbook every 5 minutes and run the macro quite easily.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Have a look at the Ontime method in VBA help. There are examples which show you how to do this. If you need any help with it then please repost.

    regards,
    Dan

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com