How do I set a reference to Microsoft XML v6.0 in VBA on a Mac?
SEONGJAE KO
1
Reputation point
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