How do I set a reference to Microsoft XML v6.0 in VBA on a Mac?

SEONGJAE KO 1 Reputation point
2021-08-16T02:48:23.317+00:00

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