wait before executing rest of a macro

[Luc]

how can you have a macro wait until a external connections have been updated
before contunueing?

practically, the macro has to wait until the following code has been
finished before continueing.

ActiveWorkbook.RefreshAll

Tried Application.Wait (Now + TimeValue("0:00:15")) but this stops
everything, even the refresh.

 

[Héctor Miguel]

hi, Luc !

how can you have a macro wait until a external connections have been updated before contunueing?
practically, the macro has to wait until the following code has been finished before continueing.

ActiveWorkbook.RefreshAll

Tried Application.Wait (Now + TimeValue("0:00:15")) but this stops everything, even the refresh.

if 15 seconds are enought wait-time for the rest of your procedure... try using two macros (i.e.)

Sub Macro1()
ActiveWorkbook.RefreshAll
Application.OnTime Now + TimeValue("0:00:15"), "macro2"
End Sub

Sub Macro2()
' here the rest of your procedure... '
End Sub

hth,
hector.

 

[Luc]

great help, thanks Hector

hi, Luc !


if 15 seconds are enought wait-time for the rest of your procedure... try using two macros (i.e.)

Sub Macro1()
ActiveWorkbook.RefreshAll
Application.OnTime Now + TimeValue("0:00:15"), "macro2"
End Sub

Sub Macro2()
' here the rest of your procedure... '
End Sub

hth,
hector.

 

[Héctor Miguel]

great help, thanks Hector

thanks for your feed-back, Luc

regards,
hector.

__ OP __