Get route coordinates from VBA

[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.