enterprises1
New Member
- Joined
- Oct 9, 2006
- Messages
- 1
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
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