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
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
Last edited: