Hi,
Quote:
What I'm trying to do is having a spreadsheet that has a street name in one column and then two subsequent columns
with the first cross street and second cross street. In other words a street segement. If I can import this
information into mappoint from excel, then I would like instead of pushpins, mapoint to draw a route on the road
segement from the first cross street to the second cross street. Once I have this route drawn on the map, then if
possible could I export the lat/long or any other type of reference information back to excel so the reference could
be used in other mapping program
|
Import / export is not a problem, also you can do a lot in VBA like drawing the road segment. However there is 1 main problem, you dont have the coordinates of the crosspoint itself (or do you ?).
If you ask mappoint to draw a route from a street to another street, I think it will draw it from the middle of the street or maybe one of the endpoints, but a crosspoint I dont think this can be done without coordinates.