search xml file for text between two tags

[blazerowners]

What's the best way to go about searching an external xml file for the text between two tags and assigning that text to a string? Some of these xml files can get rather lengthy and I'm trying to figure out the most efficient way possible.

Thanks!

[Mark Sreeves]

What language will you be using?

[blazerowners]

Visual Basic...

[Cander]

lets say you have an xml doc myxmldoc.xml that looks like this

<blah>
  <test>hiya</test>
</blah>

to get the text in test:

Dim xmlDoc As MSXML.DOMDocument
Dim xmltext as string
Set xmlDoc = New MSXML.DOMDocument
xmlDoc.async = False
xmlDoc.load "c:\myxmldoc.xml"
xmltext = xmlDoc.selectSingleNode("blah/test").text

[blazerowners]

I'm using XSLT on this XML file as well.... How would you apply a XSL transformation to the example you provided?

Thanks for the help. Your explanation makes good sense.

Tom
www.blazerowners.com
Chevy Blazer Owner's Club