Developer technologies | Visual Basic for Applications
An implementation of Visual Basic that is built into Microsoft products.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am using Office 365 (excel 16.52) on MacOS (Bigsur).
Inside the VBE, Go to Tools -> References, then find Microsoft XML, v6.0
but, References (Microsoft XML v6.0) are missing.
how do i set a reference to Microsoft XML v6.0..
My VBA code is..
Sub XML_parse()
Dim oXMLFile As New DOMDocument60
Dim codeItems As IXMLDOMNodeList
Dim codeContents() As String
Dim index As Integer, codeLength As Integer, cnt As Integer, xmlFileCounts As Integer
Dim code As IXMLDOMNode
An implementation of Visual Basic that is built into Microsoft products.