Using position() in XmlDataQuery
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 |
All times are GMT +1. The time now is 01:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com