xml - How do I initialize an IXMLDOMNode in VBA? -

when use code in excel vba macro:

dim xmlknoten new ixmldomnode 

i error. how initiate right?

the initiation of domdocument works:

dim xmldoc object set xmldoc = createobject("msxml2.domdocument") 

thanks helping.

first, ensure have microsoft xml reference enabled (my version v3.0). once have enabled, code should work, if doesn't can write this:

dim xmlknoten new msxml2.ixmldomnode 

hope helps.