tdowd/excel-geocoder

Local characters

otofoto opened this issue · 4 comments

otofoto commented

Doesn't seem to support local characters

Cēsu novads, Cēsis, Bērzaines iela 34
returns Not Found (try again, you may have done too many too fast) but can be found in Google Maps

tdowd commented

thanks for commenting on this. i am able to successfully geocode that address with google's free geocoder but am having trouble with the enterprise geocoder. let me investigate if it is an encoding/decoding issue and i will get back to you.

otofoto commented

It seems to be issue with Visual Basic local character support. Not sure how to make it unicode or at least locale compatible.

maximnl commented

you need to replace address coding old code to new:
WorksheetFunction.EncodeURL(address)

Darkguardian21 commented

I copied the code and I am getting this error. Sorry, I am not an expert on this
image