Question:
I’m using MSXML to create a DOMDocument and add nodes and attributes. When I’m done, I’d like to save the XML text into a string. Unfortunately, the Save method outputs text only to a file or to an IStream object. I tried to use the Stream object from ADO (ActiveX Data Objects) 2.5 but that didn’t work. How can I get the XML text into a string?
Answer:
This is an easy one. Once you have your document (let’s call it xmlDoc), then converting it into a string is as simple as saying:
dim xmlStr as StringxmlStr=xmlDoc.xml
Similarly, the document’s loadXML method will take an XML string as an argument and convert it into an XML DOM:
xmlDoc.loadXML "" - This is a test