Hello All,

I'd like to write a VBA code which lookup for city names on internet (e.g. Google maps, etc.) and replace the city name in my excel.

For example: I have city names with "special characters" on my excel sheet: Bad K�tzing, W�rzburg, J�rf�lla, etc. These cities' names contains ü, ö, é, á characters, so I can not correct these with a function. I do not have geo code or coordinates, so it makes difficult for me, but I saw examples to use internet application, db-s where the code can lookup for city names.

Do you have any idea for the above "issue"?

Thank you in advance!