I am generating xml using excel 2007 vba. After executing macro, I am getting this output
but I need output like
I dont want < and > instead of < and > tags.The macro that I am using is \[code\]enter code hereDim xmlDoc As New MSXML2.DOMDocument30Dim objNode As MSXML2.IXMLDOMNodeDim personNode As MSXML2.IXMLDOMNodeDim imagesNode As MSXML2.IXMLDOMNodeSet objNode = xmlDoc.createNode(NODE_PROCESSING_INSTRUCTION, "xml", "")xmlDoc.appendChild objNodeSet objNode = xmlDoc.createNode(NODE_ELEMENT, "root", "")Set personNode = xmlDoc.createNode(NODE_ELEMENT, "person", "")objNode.appendChild personNodeSet imagesNode = xmlDoc.createNode(NODE_ELEMENT, "images", "")personNode.appendChild imagesNodeimagesNode.Text = "<image href="http://stackoverflow.com/questions/14548741/& Chr(34) &"file:///Users/d.jahr/Desktop/XML Booklet/Bilder/pic1.jpg" & Chr(34) & "/>"xmlDoc.appendChild objNodeSet objNode = NothingMsgBox xmlDoc.XMLxmlDoc.Save ActiveWorkbook.Path & "\" & "result.xml"\[/code\]End SubPlease help me.Thanks