Tom Martin wrote:
The code posted by William usedThe code that you provided was helpful and here is what I did attached to a button click... Dim objXML As New MSXML2.DOMDocument Dim NodeList As MSXML2.IXMLDOMNode Dim xNode As MSXML2.IXMLDOMNode objXML.async = False objXML.Load ("C:\Documents and Settings\Tom\Desktop\new xml test aop.xml") 'objXML.Load ("c:\users\BillGates\Documents\competition.xml") Set NodeList = objXML.selectSingleNode("/ArrayOfCompetition/Competition/EventName")