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!

Have a look in the vba help index for enableevents
--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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
SalesAid Software

"Don Guillett" wrote in message
...
Have a look in the vba help index for enableevents
--
Don Guillett
SalesAid Software

wrote in message
oups.com...
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!

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

On Jan 2, 1:55 pm, "Don Guillett" wrote:
--
Don Guillett
SalesAid Software
"Don Guillett" wrote in l...

Have a look in the vba help index for enableevents
--
Don Guillett
SalesAid Software

wrote in message
roups.com...
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!