In Excel 2003 Professional, is it possible to do the following using
XmlDataQuery - ie: use the "position()" function in the XPath:


CType(ThisWorkbook.Worksheets(1),
Excel.Worksheet).XmlDataQuery("/Doc/LineItem[position()=1]/Field")


Where the XML in the map is:


<Doc
<Stuff/
<MoreStuff/
<LineItem
<FieldFirstField</Field
</LineItem
<LineItem
<FieldSecondField</Field
</LineItem
</Doc


And have it return the cell for the "SecondField "? The XmlDataQuery
always throws an exception for me.


The reason I ask is because I need to find the cell and change it's
background colour. I only have the XML available, and it's the XML
that's telling me which cell to modify.


Thanks,
d