tags:

views:

373

answers:

1
+1  Q: 

Geocoding using Google Earth

Dear all,

I would like to get a pair of coordinates (longitude, latitude) from a postal address.

I am coding VBA in an Excel workbook. I can assume that Google Earth is installed and registered as COM server. Thus I have been looking for a way to use the Google Earth COM API to achieve this, however I have not managed to find anything.

Most of the hits I found on the web are for web programmers and are about using the "Google geocoding API" which is JavaScript, which I think is not feasible for my case.

+2  A: 

Why do you want to use Google Earth? It can't geocode if the computer is not online, and if it is online, you may as well use the web apis directly. There are lots of examples of using VBA to access geocoding apis on the web, both with Google, and with other providers (Bing, Yahoo, etc.).

Note that if this is for a private application, rather than one that anyone can download, it may be against the Google terms of service, and you may need to use a different provider. See this question in Google's FAQ.

rjmunro  2009-11-12 11:08:45
Hi rjmunro. Although this does not directly answer my question, I just realized there will probably never be a better answer than yours, thus the late acceptance.
chiccodoro  2010-04-21 11:28:58

related questions

How can I refresh all the pivot tables in my excel workbook with a macro?
MS Access - Controlling another database in VBA
Deleting a file in VBA
How do you prevent printing dialog when using Excel PrintOut method
SQLite UDF - VBA Callback
Function Overloading in Excel VBA
How do I keep RecipientTime when executing MailItem.Move in an Outlook macro?
How do I assign a keyboard shortcut to a VBA macro in Outlook 2007?
Visual studio automation: Enumerate opened windows upon solution loading.
Hiding data points in Excel line charts
How do I create a status dialog box in Excel
Modifying a spreadsheet using a VB macro
Count a list of cells with the same background color
Templates In VB
Best way to test a MS Access application?
How do I read/write Person metadata from a Word doc stored in SharePoint using VBA or VSTO?
Excel VBA: Alternative IDE
good directory picker for visual basic macros in MS Outlook (2007)
Zoom for a windows form in C#
Excel: list ranges targeted by INDIRECT formulas
What is the best way to package and distribute an Excel application.
Alternating coloring groups of rows in Excel
Word Automation: Write RTF text without going through clipboard
How to parse XML in VBA
Refresh Excel VBA Function Results