View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] daniroy@gmail.com is offline
external usenet poster
 
Posts: 39
Default Pause a macro for some time

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!