I am running a macro via VBA in Excel and I want the macro topause for a time period of less than a second (maybe 200ms) in aloop. I tried using the Application.Wait method, but theminimum wait period is 1 second. I've been driving myself nutstrying to create a WScript object in VBA and use the sleepmethod with no success. Any advice on how to use WScript.Sleepmethod, or any other more appropriate method, would beappreciated.

--------------------------------
From: Daryl Wilson

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>UwbFDbgr/0+W9fNjWnKkvg==</Id>

Daryl Wilson via .NET 247 wrote:

The WScript object is built-in to the WSH host EXEs (wscript/cscript.exe)
and is not externally creatable. In VBA you have access to the Win32 API so
you could simply declare and call the Win32 Sleep function. Of course, that
puts the entire thread to sleep so it may not accomplish what you need.


--
Michael Harris
Microsoft MVP Scripting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Please ask follow-up questions via the original newsgroup thread.