I have an Excel user defined function to return the round trip distance between three way points (the start and end waypoints are the same address). I know Mappoint will report a trip duration in hours and minutes once the "get directions" icon is involked. Is there a way to return the trip duration programmatically using VBA in Excel. I have searched through the Mappoint Object Model but don't find any memebers that would return trip duration.
Thanks for any help!