Get data from web (XML) does not provide the data

[Saab95]

Hi there,

I have done an import data from web of the following xml (https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml?)
However after import I get only this

and not all the data.

Any idea ?

Thanks in advance

 

[DacEasy]

Hmmm, try the macro below to see if it imports:

Option Explicit

Sub forImportXMLdataFromWebsite()
    ActiveWorkbook.XmlImport URL:= _
        "https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml?", ImportMap:= _
        Nothing, Overwrite:=True, Destination:=Range("$A$1")
End Sub

 

[Saab95]

Hmmm, try the macro below to see if it imports:

Option Explicit

Sub forImportXMLdataFromWebsite()
    ActiveWorkbook.XmlImport URL:= _
        "https://www.ecb.europa.eu/stats/eurofxref/eurofxref-daily.xml?", ImportMap:= _
        Nothing, Overwrite:=True, Destination:=Range("$A$1")
End Sub

Thanks it worked. Weird that it doesn't with the Excel build-in import data function.

 

[DacEasy]

I used the macro recorder to create it.

Basically I went to Data - From Web - pasted in the web address, clicked Go - Next - Import.
It warned me that this XML does not refer to a schema, click OK.
Pick cell A1 and it dropped right in.