Would be the same as Dim oXml As MSXML2.DOMDocument60 Could someone give me a hand?Īs second issue I would like to ask if Dim oXml As MSXML2.DOMDocument Which is confirmed by the fact that the Msgbox "how many queries" gives 0 as result. The loop does not get read, meaning (I guess) that Queries is not looped at all. This code seems to be understood by VBA but it does not read the contents. ThisWorkbook.Sheets(3).Cells(i, 2) = Query.SelectNodes("Query").iTem(0).Text ThisWorkbook.Sheets(3).Cells(i, 1) = "Works" MsgBox "how many Queries " & Queries.Length Set Queries = oXml.SelectNodes("/concepts/Queries") ThisWorkbook.Sheets(3).Cells(i, 1) = "before loop" OXml.LoadXML ("C:\folder\folder\name.xml") So far I am doing: Dim oXml As MSXML2.DOMDocument
I have read several articles and posts in internet like below but I could not come up with a solution: I need to parse hundreds of XML files having all the same structure as follows:
0 kommentar(er)
