read data element from XML file
I've got a Excel worksheet that needs to lookup data values in a XML file.
If the XML file is formated as such:
File_1
ParentNode1
ChildNode1
DataElement1
DataElement2
DataElement3
ChildNode2
DataElement1
DataElement2
ParentNode2
ChildNode1
DataElement1
DataElement2
DataElement3
ChildNode2
DataElement1
DataElement2
How would I lookup the data value in ParentNode2\ChildNode1\DataElement2? I
am using a reference to Microsoft XML v.4.0 in the code explorer for this
workbook.
Thanks In Advance.
|