Get route coordinates from VBA

[gonen]

Hello

I am new here, and I am not sure if my request can be satisfied here.

I need to get the route coordinates between two points using excel VBA.

e.g. - Paris to London

I need to use this coordinates to draw a route on a map using KML.


Thank you for your suggestions.

[routeconverter]

I need to get the route coordinates between two points using excel VBA.

e.g. - Paris to London

I need to use this coordinates to draw a route on a map using KML.

Hi gonen,

that means you need to geocode the names of the points (Paris, London) to coordinates (9.424,51.213) and then create a KML file from it. Since RouteConverter is written in Java and you'd like to use Excel VBA, you might need a different starting point for your project or learn Java.

[gonen]

I need to get the route coordinates between two points using excel VBA.

e.g. - Paris to London

I need to use this coordinates to draw a route on a map using KML.

Hi gonen,

that means you need to geocode the names of the points (Paris, London) to coordinates (9.424,51.213) and then create a KML file from it. Since RouteConverter is written in Java and you'd like to use Excel VBA, you might need a different starting point for your project or learn Java.

---

Thanks for your reply.

If there is an API that I can use from JAVA - that will accept start and end coordinates and return all the route points between them, I can invoke Java from my VBA...

Is there an API ?

many thanks

[routeconverter]

Is there an API ?

Yes, there is a page with all the information for developers.