dim xmldoc as new xmldocument()
xmldoc.load("your xml file")
dim nodelist as xmlnodelist
dim nodes as xmlnode
for each nodes in nodelist
Guys - thanks for th comments - much appreciated. Unfortunately the XML file is more complex than originally anticipated. It gives a base currency and a foreign currency and also specifies 3 ranges. check this out:
So I'll have to extract each base and foreign value. Compare to my 2 originals. If they match then I have to extract the ranges and compare to my value. Depending ion what this is I the extract the correct fx value.
Sound fairly mucky doesn't it?
The text you have shown is not a well formatted XML file as far I I know.
When I try to open this with any XML viewer, it gives errors.
First, <base ="eur"> is incorrect. For a well formatted file it should be something like <base name="eur">.
Also the base-value nodes aren't ended (</base-value>)