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


0 comments No comments
{count} votes