Can I use msxml to parse my treeview node keys? 1

[paron]

If I use a treeview control (VBA) with the node keys structured like:

node.key = & _
&quot;<OrganizationID>1234</OrganizationID>&quot; & _
&quot;<PositionID>3456</PositionID>&quot; & _
&quot;<PersonID>5678</PersonID>&quot;

I wondered if I could then use the MSXML to retrieve -- oh, the OrganizationID, say -- out of the node's key? I could write a parser to do that, but it seems like it ought to be possible to use MSXML, somehow.

If I am talking all crazy here, please go ahead and say so, and I'll get started writing a parser.

Ron

 

[palbano]

If you have access to an MSXML ActiveX control you can use the loadXML() method to parse a string of "Valid" XML. What you have in your post is not valid XML.

-pete

 

[paron]

Thanks for the quick answer! How about:

node.key = &quot;<keydata>&quot; & _
&quot;<OrganizationID>1234</OrganizationID>&quot; & _
&quot;<PositionID>3456</PositionID>&quot; & _
&quot;<PersonID>5678</PersonID>&quot; & _
&quot;</keydata>&quot;

Should I assume from your answer that I could just put that whole string in the ()s, like:

loadXML(

&quot;<keydata>&quot; & _
&quot;<OrganizationID>1234</OrganizationID>&quot; & _
&quot;<PositionID>3456</PositionID>&quot; & _
&quot;<PersonID>5678</PersonID>&quot; & _
&quot;</keydata>&quot;

)
?

Or even loadXML(node.key)?

Ron

 

[palbano]

Ron,

Yes your XML appears to be “well formed”. A simple way to test it is to save it to a file with a .xml extension and open it in MS Internet Explorer. It will use the MSXML parser for you and report any errors during parsing in the browser window.

loadXML(node.key)

would be preferable if it works. Your question at this point is really a VBA question and I won’t even go there. I have a major aversion to VB and it’s hell spawn children VBA, VBS LOL

-pete