Retrieving the First Matching Node : XML Data « XML « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. XML
  3. XML Data

Retrieving the First Matching Node

 
Sub SelectSingleNode() 
    Dim xmldoc As MSXML2.DOMDocument50 
    Dim xmlSingleNode As MSXML2.IXMLDOMNode 
    
    Set xmldoc = New MSXML2.DOMDocument50 
    xmldoc.async = False 
    xmldoc.Load ("C:\yourFile.xml") 
    Set xmlSingleNode = xmldoc.SelectSingleNode("//Name") 
    If xmlSingleNode Is Nothing Then 
        Debug.Print "No nodes selected." 
    Else 
        Debug.Print xmlSingleNode.Text 
    End If 
    Set xmlDoc = Nothing 
End Sub








Related examples in the same category

1.Loading and Retrieving the Contents of an XML File
2.Working with XML Document Nodes
3.Retrieving Information from Element Nodes
4.Retrieving Specific Information from Element Nodes