Dim XML As DOMDocument 'xml 对象 Dim XmLRoot As IXMLDOMElement 'xml根节点 Dim I As Integer Set XML = New DOMDocument If XML.Load("c:\TDDOWNLOAD\200901.XML") = False Then MsgBox "打开xml出错!" Exit Sub End If Set XmLRoot = XML.documentElement '建立根节点对象 For I = 1 To XmLRoot.childNodes.length MsgBox XmLRoot.childNodes.Item(I).nodeName '获得所有根节点下所有子节点的节点名 MsgBox XmLRoot.childNodes.Item(I).Text '获得所有根节点下所有子节点所含的文本内容 Next Set XML = Nothing