+ Reply to Thread
Results 1 to 3 of 3

Best way to pause?

  1. #1
    Registered User
    Join Date
    11-13-2004
    Posts
    49

    Best way to pause?

    I am running a WinHttp.WinHttpRequest and would like to pause in between loops. Currently I have Application.Wait Now + TimeSerial(0, 0, 5) During the pause the CPU gets up to 100% and remains there until the pause is done. Is there a better way to put a pause in a macro that is less taxing on the CPU?

  2. #2
    Registered User
    Join Date
    11-13-2004
    Posts
    49
    I've tried this but it seems to freeze in excel Application.OnTime Now + TimeSerial(0, 0, 5), "GetResults"

  3. #3
    Registered User
    Join Date
    11-13-2004
    Posts
    49
    the Ontime function does work, but it doesn't show screen updates or allow me to work with excel when its running. Here is what I have with Ontime Application.OnTime Now + TimeSerial(0, 0, 5), "GetResults" Have I not entered it correctly or something? Is it freezing because its set for a short period of time?

+ 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