Hi everyone,

I am very new to VBA and XML in general.

I need some help with MSXML2.DOMDocument object. I am using VBA and have the following scenario.

I have an XML structure as follows:

<SomeRootElement>
<Input>
</Input>
</SomeRootElement>

Then I have another XML structure as follows:
<Output>
<SomeElement>
</SomeElement>
</Output>

Now what I want to do is combine these XML structures, so I have:
<SomeRootElement>
<Input>
</Input>
<Output>
<SomeElement>
</SomeElement>
</Output>
</SomeRootElement>

basically, add the second XML structure as a child to the root element.

How can I do this using VBA?

Thanks!
Cheers!
xargon

I realize this is an old post but I've been working on this subject and this was the first hit on Google. Need to reference Microsoft XML in your project.

Sub MergeXML()

   'Define
   Dim oXml As New MSXML2.DOMDocument
   Dim oXml2 As New MSXML2.DOMDocument

   'Assign
   oXml.loadXML ("<SomeRootElement><Input></Input></SomeRootElement>")
   oXml2.loadXML ("<Output><SomeElement></SomeElement></Output>")
   'or assign via file
   'oXml.Load("c:\Xml.xml")
   'oXml2.Load("c:\Xml2.xml")

   'Process
   oXml.FirstChild.appendChild oXml2.selectSingleNode("//Output")

   'Destroy
   oXml.Save ("c:\NewXml.xml")
   Set oXml2 = Nothing
   Set oXml = Nothing

End Sub