Excel Geocoding Tool v2

I'm happy to announce a few small revisions to our Excel geocoding tool. The tool takes a list of addresses and will look up the latitude and longitude of those addresses. The addresses can then be exported as a Google Earth map.

A user pointed out that the tool wasn't looking up zip+4 codes properly in Yahoo and this problem is fixed along. Also, I'm sorry to report that Yahoo has lowered their limit of free geocodes to 5,000 per day from 50,000 per day.

Geocoding Tool v3.1.xls

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License. All source code is released under a BSD License unless otherwise specified.

65 comments | Show all comments only the last 5 are shown


November 3, 2009
Marian said:

hi there,
has anyone got a solution concerning the "http:send" line yet?
the macro always seems to stop at that point.
thanks for your help
marian


November 11, 2009
Chrispy1 said:

Hi Marian,

I'm running into the same problem and believe it's because I'm running the code while inside my company's firewall. if i'm at home and not connected to my company's network, everything runs beautifully. I'm currently investigating a workaround, and will post back here if I figure something out.....
Chris


December 3, 2009
Marian said:

hi folks,
in my case it doesn`t work at home either :( not sure whether the firewall is causing this problem. Chrispy, did you work it out yet? appreciate any help on this.
cheers
marian


February 3, 2010
Fillipe said:

Hi All,
I had the same problem at the company's network. I just unplugged the cable and went to the aircard and it worked. So it must be something related to firewalls.
Cheers
Fillipe


February 4, 2010
Kirnbauer said:

Hi,
When I use the latest geocoder tool (v3.1.xls) and click view in google earth, I get a message that says "could not open file documents output.kml" - how do I fix this? I don't want to have to click "ok" then navigate to the file and double-click it (which will work but is not ideal).

Many thanks.

Your name

Email (optional, will not be shared)

Type the word "juice" (required to confuse the spammers)

Your comment


Add a comment