wait macro while database is being refreshed

[enterprises1]

Hi all,
I am new on this websites as I started with Excel few years ago and my knowledges are not so exciting. However try to do some things on my own. I try to run some macro in my excel sheet called RoutesQuery. We have 3 drivers and everyone has his own route with the customers. I take the data from external database and try to put it into macro to be able to overwrite the route for every driver automatically and print out the sheet. When I use the macro button it works but macro does not wait until the data from the database are refreshed. It means I have finaly 3 the same pages for the same route and the rest is not created. Could anyone help how to sort it out?
Thank you in advance.
Martin

 

[Oaktree]

Welcome to the board.

Use BackgroundQuery:= False as in:

Range("A5").QueryTable.Refresh BackgroundQuery:=False

 

[Legacy 98055]

See the second code example in this post.