Display MoreRe: Looking everywhere for VBA to do reverse geocoding, not just for address
The latitude and longitude coordinates for the Statue of Liberty are 40.71277200 and -74.00605800 respectively. This is exactly how they need to look (formatted) when they are passed to the XMLerverReadLB macro for it to work.
Spanish regional settings would return 40,71277200 and -74,00605800 (note the comma as opposed to a dot). You did not notice this???
I have incorporated Krishnakumar's nifty patch in the attached workbook.
Robert
Hi Trevor,
I was looking for the exact same question and download your file to test, but upon runnin the reversegeo code vba module, it took forever and crashed
Am I missing something? I havent changed anything in the workbook you [provided