Dashboard > Public Content > ... > ExcelVBA > Get An XML Node
  Public Content Log In   View a printable version of the current page.  
  Get An XML Node
Added by James Richardson, last edited by James Richardson on Jun 28, 2006
Labels: 
(None)

Function getNodeFromDocument(document As DOMDocument, nodename As String, default As String) As String 
    Dim nodeList As MSXML2.IXMLDOMNodeList 
     
    If (document Is Nothing) Then 
        getNodeFromDocument = default 
    Else 
        Set nodeList = document.getElementsByTagName(nodename) 
         
        If (nodeList.Length > 0) Then 
            getNodeFromDocument = nodeList.Item(0).Text 
        Else 
            getNodeFromDocument = default 
        End If 
    End If 
 
End Function
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.5.1 Build:#806 May 06, 2007) - Bug/feature request - Contact Administrators