search

tdowd / excel-geocoder

A VBA application for geocoding and reverse geocoding in Excel. Supports both Google's free and enterprise for business geocoder (Maps API for Work).
MIT License
42 stars 22 forks source link

Local characters #6

Open otofoto opened 6 years ago

otofoto commented 6 years ago

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 6 years ago

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 6 years ago

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 5 years ago

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

Darkguardian21 commented 1 year ago

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