Share via

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

SEONGJAE KO 6 Reputation points
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

....

Developer technologies | Visual Basic for Applications
0 comments No comments
{count} vote

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.