I have a desire to create a matrix of milages between 2 sets of puchpins.
call one set warehouses and the other set customers
I have been doing this manually bu using 2 warehouses as start and end poins and the customer as a way point and routing it. then taking start to waypoint as 0ne milage and waypoit to end - start as the distance between the other.
surely this could eb done with vb. can someone point me int he right direction. ideally I would write directly to access or excel
in the format of name 1, name 2, milage
that I could then put into a matrix.