Excel VBA to convert XML file from string to line by line

[MichaelRSnow]

Hi

Does anyone know if VBA can read an XML text string and every time it hits a less than symbol "<" to moves it down a line (carriage return)

I know I can get a XML line by line converter via Notepad++, which is great but I'm trying to remove this step from a process when converting some data in the xml.

Pulling my hair out looking for a solution?

Thank you

for example
<Detail_Collection><Detail textbox4="No Change" textbox8="122559" /><Detail textbox4="No Change" textbox8="122560" />

would become
<Detail_Collection>
<Detail textbox4="No Change" textbox8="122559" />
<Detail textbox4="No Change" textbox8="122560" />

 

[Haluk]

You can use "MSXML2.DOMDocument" object to read the data in the XML source.

If its on the net and if you can give the URL, I can help.

 

[MichaelRSnow]

You can use "MSXML2.DOMDocument" object to read the data in the XML source.

If its on the net and if you can give the URL, I can help.

The XML file is on my local drive (not the net) and the hope was to have VBA (via Excel) open and complete carriage return before each < symbol,

example string is shown below

<Detail_Collection><Detail textbox4="No Change" textbox8="122559" /><Detail textbox4="No Change" textbox8="122560" />

 

[Haluk]

Without seeing the whole XML document, its hard to answer your question.

If you wish, you can PM me to send the XML file to me. Then, I can try to make my best...

 

[MichaelRSnow]

How do I upload the xml file on here? can't see an obvious route?

 

[Haluk]

You can use "Google Drive" or a similar site to upload your file and give the download link, here.