Transfer data from XML DOM Document to spreadsheet

[skazis]

Hello,
I reached the place where I read in *.xml from the web as DOM document to access nodes and manipulate them, but I can't seem to find a way to get values from DOM document to spreadsheet. I used real link, so nodes can bee looked up there. I'd like to paste all "price" nodes in my spreadsheet "Sheet1", cells(1,1). Here is the code:

Please Login or Register  to view this content.

[Chippy]

I'd like to paste all "price" nodes in my spreadsheet "Sheet1", cells(1,1).

Within the For Next loop put:

Sheets("Sheet1").Cells(1, 1).Value = Sheets("Sheet1").Cells(1, 1).Value & " " & oXmlNode.Text

[skazis]

That did the trick. Thank you. And could you please tell how to put these values each in a new cell? I tried FOR loop and variable within Cells(i,1), but for each i loop cycled trough nodes and at the end put the last value and I ended up with all cells equal to last value of nodes.

[skazis]

I am getting better, did it on my own.

Please Login or Register  to view this content.