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>
<Field>FirstField</Field>
</LineItem>
<LineItem>
<Field>SecondField</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