VBA Compare 2 XML nodes to see if they are the same node

Question

In VBA (with reference to MSXML2.DOMDocument60) I have two nodes:

Dim nodeFoo As MSXML2.IXMLDOMNode
Dim nodeBar As MSXML2.IXMLDOMNode

These nodes are assigned values, for what its worth nodeFoo is assigned via an xPath expression whereas nodeBar is assigned by looping through a set of nodes.

The challenge is to determine if: nodeBar = nodeFoo (i.e. if it is the same actual node).

Searching google suggested it is possible using isSameNode but I'm unable to find an equivalent in MSXML2.

https://stackoverflow.com/questions/11254401/vba-how-to-test-for-object-equality-whether-two-variables-reference-the-same-o — Tim Williams, Oct 06 '17 at 06:03
Works, I think the question is fair and adds value - if you care to answer it I'll accept — SlowLearner, Oct 06 '17 at 06:06

score 1 · Accepted Answer · edited Oct 06 '17 at 06:15

1

Typically you'd use Is to determine whether two object variables point to the same object.

E.g. see VBA: how to test for object equality (whether two variables reference the same object)

Example:

For Each nodeFoo In allNodes
If nodeFoo Is nodeBar Then 
    ' do something

edited Oct 06 '17 at 06:15

SlowLearner

3,086
24
54

answered Oct 06 '17 at 06:08

Tim Williams

154,628
8
97
125

Thanks for that - I was going insane looking for something similar to isSameNode – SlowLearner Oct 06 '17 at 06:12

VBA Compare 2 XML nodes to see if they are the same node

1 Answers1