Pause a macro for some time

[daniroy]

Hello there and happy new year to all, and as always thank you very
much to all people providing this so much look after help.

I have design the full process of my data retrieval in the following
way:

Sub Global
Sub1
Sub2
Sub3
Sub4
End Sub

The point is once Sub2 is launched it needs one minute or so to
retrieve datas through DDE links to another application,
so when Sub3 is launched, Sub2 did not finished to retrieve these datas
and the results are so meaning less.
I tried to use Wait argument as

Sub Global
Sub1
Sub2
Application.Wait (Now + TimeValue("0:01:00"))
Sub3
Sub4
End Sub

And Wait stop the full process while Sub2 should continue to retrieve
datas. As the datas are not retrived it is useless.
What I would need is just nothing to happen for a minute - time for
datas to be downloaded, and then, and only then would run Sub3 and Sub4

Many thanks your help would be much welcomed!

 

[Don Guillett]

Have a look in the vba help index for enableevents

 

[Don Guillett]

--
Don Guillett
SalesAid Software
(e-mail address removed)

 

[daniroy]

the help file is very clear ...
but how to implement anything holding on everything for a minute or so?
regards
Daniel