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?