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.