How To Do Relative xPath In CustomXMLNode?

howdy

this code, which loads a KML file, is working great. I'm getting the coordinates of the current oCustomNode:

Please Login or Register  to view this content.

but, would prefer to use relative xPaths, instead of index numbers.

how?

this does not work:
Debug.Print oCustomNode.ChildNodes("Point/coordinates").Text

Thanks.

Hello johnywhy,

Our Forum Rules ask that you please list links to all sites where you have posted the same question. This keeps everyone who is helping you informed about solutions that have been proposed, rejected, and accepted.

As a new member, please take some time to familiarize yourself with the rules.
Forum Rules

Cross posted at: http://www.mrexcel.com/forum/showthread.php?t=518569

resolved.... I got around this by using the DOM method, instead of CustomXMLPart's.

CustomXMLPart's need namespace and other xPath weirdness that i don't get, and CustomXMLPart's appear to be tangled up in the Excel workbook structure. The DOM method does not involve Excel at all, so this can be ported to .NET.

Please Login or Register  to view this content.

This allows me to use simple xPath expressions as above. I can use oNode.SelectNodes to get child nodes relative to oNode using xPath...

Please Login or Register  to view this content.

CustomXMLPart's also have a SelectNodes method on the CustomXMLNode object, which is the answer to my original question. But i prefer the DOM method for reasons mentioned above.

Requires reference to MSXML (Microsoft XML). sKmlUrl can be a local filepath or a url.

Hello johnywhy,

Generally, it is better to post your question at a single site. But if you need an answer faster to complicated question then posting in several places makes sense. Thanks for posting the answer.

Generally, i disagree. I appreciate the service you provide. But I've never seen any other forum which requires me to report to you what other websites I post my question to.

My activity on other websites, which are not related to your website, and which may have an entirely different readership than your website, is my own business.

It's fine to ask people to not post the same question in multiple places on your site, aka "cross-posting". But if I post the same question on other websites, that is not cross-posting.

Hello johnywhy,

You certainly have presented a convincing counterpoint to the standing policy. As a moderator, changes to policy lie outside my purview.

Periodically policies are reviewed. During our next session, I will present your post for discussion and consideration to those who make the board policies.

My activity on other websites, which are not related to your website ... is my own business.

But if I post the same question on other websites, that is not cross-posting.

That will get you banned here if you continue to do so without posting links. That is our policy; you need not agree, but you may wish to be aware.

no need, i'm canceling my account. but, for you to ban someone for what they post on other websites, or to require people to provide links to their posts on other websites, is retarded. you do not own the internet. and i DID list other sites where i posted the question.

No one wants to spend time working on problems solved elsewhere.

Happy to have you here, happy to see you leave if you prefer.

Bye.

Okay, best of luck, bye.