GeoNames Forum

Hi,

I am experiencing some troubleshooting with the XL macro I developped to geocode list of locations placed in my spreadsheet. That macro was running perfectly a month ago and is not working anymore.

I tried the following example, once directly by typing the URL in Internet Explorer and secondly using XL macro :
sendstring = "http://ws.geonames.org/postalCodeSearch?postalcode=9011&maxRows=10"
ActiveWorkbook.XmlMaps("Geo_Zip").Import URL:=sendstring

The URL works fine with IE but not with XL (And belive me I have the proper XMLMAP in the XL file)

Is there any limitation for XL users ?

David.

Hi David

There is certainly no limitation for XL users. I am not sure when the totalResultsCount element was introduced, it is possible that this broke your code.

Regards

Marc

Thank you Marc for the answer.

However, I tride to simply import data in XL : Data->Import Exter. Data-> Import Data.

I tried with the following URL :
http://api.search.yahoo.com/WebSearchService/V1/webSearch?appid=YahooDemo&query=Dan+Rather&results=10

And it works fine.

Then I tried with :
http://ws.geonames.org/search?q=london&maxRows=10

And I get an error : Could Not open 'http://ws.geonames.org/search?q=london&maxRows=10'

So I think that my problem come from geonames Vs Excel since I get the pefect answer with IE 6.0.And it works well in july.

Any idea ?

David.