Accessing XML File Directly

[MDTekUser]

I know how to access data in an XML file by opening an ADO Recordset with adCmdFile, but what I would like to do is access the XML file directly.

I would like to be able to search for the value of an element, etc. Let's say I have an Employee root element, I want to find last name Jones.

<Employee>
   <LastName>Smith</LastName>
   <FirstName>John</FirstName>
</Employee>
<Employee>
   <LastName>Jones</LastName>
   <FirstName>Sam</FirstName>
</Employee>

 

[Sheco]

You mean like loading it into the XML DOM object used by IE ?

 

[MDTekUser]

Actually this is in a visual basic forms module.

 

[EBGreen]

Then you can load it into the XML DOM as suggested by Sheco. Searching this forum for "XML DOM" returns 46 hits. I would suggest starting there.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]