且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

从VBA解析XML无法正常工作

更新时间:2023-09-27 20:31:34

只有XML格式正确,XML解析器才能工作.如果不是,则 oXMLDOMDocument.load 方法失败.

A XML parser can only work if the XML is well formed. If not, the oXMLDOMDocument.load method fails.

要对此进行检查,您可以像这样使用 oXMLDOMDocument.parseError :

To check this, you could use oXMLDOMDocument.parseError like this:

Public Function ll()

 Dim oDoc As Object
 Set oDoc = CreateObject("MSXML2.DOMDocument")
 oDoc.Load "E:\web\cc.xml"

 Dim oErr As Object

 If oDoc.parseError.ErrorCode <> 0 Then
  Set oErr = oDoc.parseError
  Debug.Print oErr.reason
 End If

 Dim oVariables As Object
 Dim oVariable As Object
 Set oVariables = oDoc.SelectNodes("/Environment/Variable")
 For Each oVariable In oVariables
  Debug.Print oVariable.SelectNodes("Caption").Item(0).Text
  Debug.Print oVariable.SelectNodes("Type").Item(0).Text
 Next

End Function

请参阅: https://msdn.microsoft.com/en-us/library/ms762722%28v=vs.85%29.aspx