Wait in vbs file

This is because Application. Wait will wait until a time is reached instead of waiting for a precise interval of time. This approach is of course less practical as usually you want to wait simply for a precise interval of time, like say 3 seconds. That is why we need to aid ourselves with the use of either the DateAdd function or the TimeValue function :. What does the function above do? It adds 1 second to the current clock time and asks VBA to wait until that moment to return from the function.

You can similarly wait for longer periods of time. If you thought those were your only options — you were wrong. VBA thankfully allows you to also use another function called DoEvents. The function seemingly…. Now why would we want to use the DoEvents function you might ask? Well, remember that Application. Wait does not allow you to wait for intervals shorter than 1 second? I completely misread your response. I didn't catch the part where you stated this has been tried times before and no solution was found.

That does change things. As Bill has pointed out you have not defined your technical requirements. Without that it will be hardd to find or even guess at an answer. That worked perfectly! Thanks a bunch! And it's so simple I'm banging my head a bit because I didn't consider it. First script sample would look for the process, if it existed, it would wait 60 seconds and try again, infinitely. If it wasn't found it would exit. If it wasn't found running, it will exit.

I remembered last night, that PowerShell doesn't process scripts chronologically. That results in "Get-Process" not ever seeing "Radpinit", since it hasn't started yet. I'm going to do some more research on script assembly and process flow. I really want to understand better how this works. Secondly, even after Radpinit has started, it will stop briefly second or less as a package completes, and restart when the next package install begins.

Kind of like a 4 year old playing with a light switch I was researching the heck out of "Do" "For" "While" loops last night, and was having trouble finding information on the different conditions that could be supplied to each. I found some examples similar to what I'm trying to do, but most of them had a page of code to do what you just did in a few characters! This is where my idea of having the While loop, "in a loop" came from.

But I realize I wasn't clear on that, at all. Anyway, thanks a lot for your help. You've definitely got me on the right track and I now know this is possible. Office Office Exchange Server. Not an IT pro? Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Download the PMSleep sources. Download the Wait. For longer delay times especially, it would be nice to let the user know what time is left. That is why I wrote CountDown.

Pressing any key will skip the remainder of the count down, allowing the batch file to continue with the next command. Download CountDown. By default it starts displaying a tooltip which will be visible for 10 seconds or any timeout specified , but the program will terminate immediately after starting the tooltip. Now is the function which will take the current time and we are adding 10 seconds to the current time through time value function so that the code can wait or pause for 10 seconds.

Currently, the time in my laptop is pm and I want the code to resume at PM. We will use simple addition to some variables but display the result after PM. We want the code to wait for that period. Step 2: Click on Insert Tab and then click on Module. Step 3: Once the code window opens up declare a sub-function to start writing the code. Step 4: Declare three variables A B and C as an integer. Step 6: Use an application. Step 8: Use a Msgbox function to display the value of C.

Step 9: Run the above code.