Forum Discussion
Getting longitude and latitude from Bing Maps API in Excel
Hi. I'm a newbie on this forum so apologies in advance If I get things a bit wrong. I have a function that uses bing maps to calculate the distance and travel time between two points defined and retu...
the URL throws up a JSON result
your VBA code does not extract data from a JSON URL
your code is capable of extracting data only from XML
you need to parse json to be able to do it