5,139
社区成员
发帖
与我相关
我的任务
分享
Sub test()
Dim xmlDoc, rootEl, child1, child2, p
'创建XML文档
'Set xmlDoc = CreateObject("Microsoft.XMLDOM")
Set xmlDoc = CreateObject("MSXML2.DOMDocument")
'创建根元素并将之加入文档
Set rootEl = xmlDoc.createElement("root")
xmlDoc.appendChild rootEl
'创建并加入子元素
Set child1 = xmlDoc.createElement("Today")
child1.Text = "A fine day"
Set child2 = xmlDoc.createElement("Tomorrow")
child2.Text = "A fine day"
rootEl.appendChild child1
rootEl.appendChild child2
'创建 XML processing instruction
'并把它加到根元素之前
Set p = xmlDoc.createProcessingInstruction("xml", "version='1.0' encoding='UTF-8'")
xmlDoc.InsertBefore p, xmlDoc.ChildNodes(0)
xmlDoc.Save ThisWorkbook.Path & "\HP_Scan_Iterm.xml"
End Sub