Time Delay with VBA 1

[uscguy22]

Hi Everyone,

I'm running a webquery in EXCEL and want to do some analysis with the data afterwards. Does anyone know how to write the code that tells Excel to wait 10 seconds while the webquery is in progress so that the web query can complete? Thanks.

 

[andyrice]

It looks like this may work.
"Use the built-in Wait method."

Application.Wait( Now + TimeValue("0:00:10") )


Andy Rice
San Diego, CA

 

[PHV]

And what about setting the BackgroundQuery property to false ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244