Excel WebService

2 posts / 0 new
Last post
Quanticware
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

 


MQBrianCoakley
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.