下面的代码示例的功能是通过VBA代码读取Excel中XML文件的内容。
Dim rst As ADODB.Recordset
Dim stCon As String, stFile As String
Dim i As Long, j As Long
Set rst = New ADODB.Recordset
stFile = “C:dzwebs.xml”
stCon = “Provider=MSPersist;”
With rst
.CursorLocation = adUseClient
.Open stFile, stCon, adOpenStatic, adLockReadOnly, adCmdFile
Set .ActiveConnection = Nothing
End With
With ActiveSheet
For j = 0 To i – 1
.Cells(1, j + 1).Value = rst.Fields(j).Name
Next j
.Range(“A2”).CopyFromRecordset rst
End With
rst.Close
Set rst = Nothing
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至 86345@qq.com 举报，一经查实，本站将立刻删除。
