What instruction do I enter to pause a macro in code

[henniec]

Good day,

I need the pause a step in my code that runs a different code in Excel. Data is extracted from a server that takes a few minutes to extract. On my personal computer I do not have a problem running the code and achieve the required result.

On my collegue's PC it is a different story as either the extracting process takes to long or the PC may be a little slower.

The timer delay code I find in the help file is for a form and not really what I am looking for.

I assume ths code will be about one line long.

Thanks.

Hennie

 

[pbaldy]

Try this:

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

Paul
MS Access MVP 2007/2008

 

[henniec]

Thank you for your reply. I do think it will do the trick. Will be able to use if future applications where needed.

Regards.

Hennie