RouteConverter Forum
Get route coordinates from VBA - Printable Version

+- RouteConverter Forum (https://forum.routeconverter.com)
+-- Forum: Users (https://forum.routeconverter.com/forum-17.html)
+--- Forum: English: Discussions (https://forum.routeconverter.com/forum-12.html)
+--- Thread: Get route coordinates from VBA (/thread-1383.html)



Get route coordinates from VBA - gonen - 30.07.2012

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.


RE: Get route coordinates from VBA - routeconverter - 30.07.2012

(30.07.2012, 04:57)gonen Wrote: 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.


RE: Get route coordinates from VBA - gonen - 30.07.2012

(30.07.2012, 09:40)routeconverter Wrote:
(30.07.2012, 04:57)gonen Wrote: 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


RE: Get route coordinates from VBA - routeconverter - 30.07.2012

(30.07.2012, 10:29)gonen Wrote: Is there an API ?

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