我用thissite中的代码创建了一个xml模式.SubCreate_XSD2()DimStrMyXmlAsString,MyMapAsXmlMapDimStrMySchemaAsString'Book.xmlisthefilecreatedinsectiononeofthistopic.StrMyXml="C:\BookData.xml"'Turnoffasyncloading.Application.DisplayAlerts=False'AddthestringtotheXmlMapscollection.SetMyMap=ThisWorkbook.XmlMaps.Add(Str

因为一个标签由数字组成，每次我想阅读它时都会发生变化，但这段代码不起作用，我在StrMyXml.nodeName(无效标识符)处收到错误。目前我的代码是这样的:SubCreate_XSD()DimStrMyXmlAsString,MyMapAsXmlMapDimStrMySchemaAsStringDimtempStringAsStringStrMyXml=""StrMyXml=StrMyXml&""tempString=StrMyXml.nodeNameStrMyXml=StrMyXml&""StrMyXml=StrMyXml&"tempString"StrMyXml=StrMyXm

我正在尝试使用ExcelVBA创建自定义XMLmap。我的XML文件是BookData.xml:989-0-487-04641-2MyWorldNancyDavolio121981-0-776-05541-0GetConnectedJanetLeverling435999-1-543-02345-2HonestyRobertFuller315我在Excel2013中的VBA代码是:SubCreate_XSD()DimStrMyXmlAsString,MyMapAsXmlMapDimStrMySchemaAsStringStrMyXml=""StrMyXml=StrMyXml&""Str