Using position() in XmlDataQuery

D

df

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

position() in XmlDataQuery 0
Using position() in XmlDataQuery 0
Merging from an Excel file with graphics 1
Function using XMLDataQuery in Excel: Not refreshing automatically on worksheet 0
How to use a single nonrepeating XML element in a cell formula 1
Creating Labels Over 3-Up Image 2
Set default for .XML (not WordML) to use XML Spy 2
Excel 2003, Convert EXISTING Worksheet Data to XML? 3

Top