VBA to wait for query to finish before starting next query in a sql refresh link

Hello all,

This might be a quick and easy one for some of you. I have a Macro created that refreshes two tables (these are connected to a view in SQL).
When we use the refresh all function we get a time out in sql as it tries to refresh the tables at the same time.

we are after some vba code to fit imbertween the three refresh codes (below) that force the macro to wait for each refresh to be completed before it starts the next. Simply put the three refreshes need to happen in a sequence and not at once.

Any help on this is greatly appreciated

Please Login or Register  to view this content.