execute code after finished refresh web query connection

Hi All,

I have a connection which is web query. I want to use macro to refresh the connection. after refresh, I want to process other code.
Would you help to revise me an idea to do that? Thanks.
let say,

Sub test()
Connections("ABC").refresh //It is a web query connection
<code to wait the connection finish refreshing.>
msgbox "finished refreshing"
processA
End Sub