Write entire XML file to Excel worksheet row by row after it has been loaded

[baggieade]

Hi

I am new to reading XML files to Excel using VBA. I can load the XML file to Excel but when I try to put the data into a worksheet it puts the entire XML contents into a single cell. What I want is each line of XML in a row in the worksheet. An alternative is to open in notepad. I can open the XML in notepad using a Shell but I can't transfer the data from Notepad to Excel.

My code so far is

 

[baggieade]

can't post the code in I have because paste won't work!!!!

Hi

I am new to reading XML files to Excel using VBA. I can load the XML file to Excel but when I try to put the data into a worksheet it puts the entire XML contents into a single cell. What I want is each line of XML in a row in the worksheet. An alternative is to open in notepad. I can open the XML in notepad using a Shell but I can't transfer the data from Notepad to Excel.

My code so far is