![]() |
|
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. 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. 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. |