The best way to pause/wait 3 seconds in in a loop?

[peskywinnets]

So I've done a lot of searching...and there seems to be much discussion &/o disagreement regarding wait/pause- worse still a lot of the code I've found doesn't even seem to work.

I've a situation where I request a report from Amazon in VBA, but it can take them up to 10 seconds to prepare the report before it's available for me to download ....Amazon get quite miffed if I request a report 'status update' too often, so I'd like the following (high level)chain of events.....

First, Request the report

Loop:
Wait 3 seconds
Check to see if it's ready (request a report status update)
If not ready yet - goto Loop

...so what's the best way to wait 3 seconds in VBA?

Many thanks.

 

[pbaldy]

How about:

http://access.mvps.org/access/api/api0021.htm

 

[peskywinnets]

That worked a treat - thanks

 

[pbaldy]

Happy to help!