2

I would like to extract data in an Excel file from an XML result of a direction query.

I use the ServiceWeb function in Excel with this request:

=SERVICEWEB("https://maps.googleapis.com/maps/api/directions/xml?origin="&A4&"&destination="&B4&"&mode=driving&key=MYKEY")

A4 is the origin: Place Bastille, Paris for example and in B4 is the destination address: Place Bellecour, Lyon.

I work in .xlsm file.

It seemed to work at first but not anymore. Am I missing something?

ZygD
  • 22,092
  • 39
  • 79
  • 102
ASR
  • 21
  • 1
  • 1
    You mean the `WEBSERVICE` function: https://support.microsoft.com/en-us/office/webservice-function-0546a35a-ecc6-4739-aed7-c0b7ce1562c4 – JMP Aug 27 '21 at 05:57
  • 1
    @JMP Microsoft - being a total pain, as usual - have made the unbelievably stupid decision to TRANSLATE all function names to other languages. The `WEBSERVICE` function, in French, is called `SERVICEWEB`. Yeah!!! So, in case OP is working with a French version of Excel, the function is correct. – MrUpsidown Aug 30 '21 at 11:22
  • @MrUpsidown; i see; I tried it in my UK Excel, and it worked, so I thought OP had made a typo! – JMP Aug 30 '21 at 11:55

0 Answers0