Mon, 07/22/2019 - 07:26
#1
Excel WebService
Hello,
I try to create a Excel file to calculate duration and distance between 2 points.
The first point is alway the same. Second change at each line.
I'm little bit lost.
=SERVICEWEB("https://open.mapquestapi.com/directions/v2/routematrix?key=MYAPIKEYVERYS...")
But I don't know how to extract time and distance.
I tried:
=FILTRE.XML(D6;"//response/time")
But #NAME error return.
Help!
Thanks
Tue, 07/23/2019 - 06:12
Is there a question about the
Is there a question about the MapQuest api or is the question about how to implement it with Excel? I can barely walk through Excel so I'm not going to be much help there.