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