I use Mappoint a lot for getting journey distances, and I automate it using VBA running from Excel. However for some locations - particularly China, Russia, and the Balkans - Mappoint doesn't have route info, but Virtual Earth/Maps Live does (much better than Google in fact).
I have been trying to get the VBA code to call Virtual Earth, generate locations and a route and collect back the journey distance and time (though journey times look pretty crude). I don't need to see the map, I just want the return values.
I can generate a HTML file that does the calling but I cannot find how to get the return values, and ideally I would do it as a URL. I think this must be something others have done...
Any thoughts, advice or links? Anything welcomed.