City lookup and correction by VBA

[peter.hernadi]

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!

[mahaveersomani]

upload the sample file so i can do something for you.


Regards
CA mahaveer Somani

[peter.hernadi]

I have uploaded the full list as I have:

Country_City_Full_List.xlsx

Thank you for the assistance!

[peter.hernadi]

Do you have any idea? Are there any solution for this or close this thread and try sg. else to resolve the question?

thanks in advance!

[peter.hernadi]

Any advice? I have the same issue now in other task.

Thanks in advance!