Results 1 to 3 of 3

Thread: Timer and Excel

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Oct 1999
    Location
    MA, USA
    Posts
    523

    Post

    I have a problem with my application. Every time I'm doing something in Excel (from my app of course) it disables my Timer (which has a really important funtion). I'm mean it doesn't really disables it, but it doesn't let the timer to do anything. Do you know what's going on?
    Thanks

    ------------------
    Visual Basic Programmer
    ------------------
    PolComSoft
    You will hear a lot about it.


  2. #2
    Lively Member
    Join Date
    Jun 1999
    Location
    Ireland
    Posts
    96

    Post

    If the app gets really busy, you may need to add the command,

    DoEvents

    somewhere inside the loop, without this if the loop takes a long time, then all processing of the code stays within your loop

    Hope this helps,

    Steve

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Oct 1999
    Location
    MA, USA
    Posts
    523

    Post

    Thanks SteveS it helped a lot!!

    ------------------
    Visual Basic Programmer
    ------------------
    PolComSoft
    You will hear a lot about it.


Posting Permissions

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



Click Here to Expand Forum to Full Width