obtain xml values

[sks04]

I have looked at numerous posts about reading/writing xml, but I am still a bit lost.

For example, what I'd like to do is; obtain the individual values per element...the DB_Name value, table_Name1 value for Fee_Sim, etc...then the values for App_Sim, etc...

- <Root_Element>
- <Fee_Sim>
<DB_Name>fc_table_content</DB_Name>
<Table_Name1>ThisToClient</Table_Name1>
<Table_Name2>ThatToBank</Table_Name2>
<UserID>sa</UserID>
<PW>password</PW>
<Server>TestServer1</Server>
</Fee_Sim>
- <App_Sim>
<DB_Name>OSI_Batch</DB_Name>
<Table_Name>Table_Master</Table_Name>
<UserID>sa</UserID>
<PW>password</PW>
<Server>TestServer2</Server>
</App_Sim>
</Root_Element

[sks04]

Actually this is very simple...

Dim X As IXMLDOMNode
Set X = XMLobj.selectSingleNode("//App_Sim/DB_Name")
Msgbox X.Text

Result: OSI_Batch