Invalid at the top level of the document XML parse in VBA

Hi Guys,

I want to get value from MID node:

"mid":3.6126

my code is (website is a true adress):

Please Login or Register  to view this content.

strXML =

{"table":"A","currency":"dolar amerykański","code":"USD","rates":[{"no":"220/A/NBP/2017","effectiveDate":"2017-11-14","mid":3.6126}]}

and error is raised:

"Invalid at the top level of the document"

What is wrong within this strXML?

Please help,
Jacek Antek

Ok,

problem is that Excel is importing from this site instead of XML format - JSON format.
It is possible to set up Excel headers to read XML directly?

Please help,
Jacek