request/response

[Joy]

when ms project sends request to server, and receives response from server.
can we write macro by vba to let ms project sleep and check every, say 3
seconds the response and decide what do to next???

I find some sleep method in vba, but still cannot figure out how to do it..

can someone share some ideas?

thanks

 

[Rod Gill]

What query are you doing that takes 3 seconds? They should all take no more
than a few milliseconds.

VBA does not have threads, but you can use the DoEvents method to let
control return to Windows so other programs get more CPU time.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com