Do any VBA libraries exist which will allow me to use XPath 2.0 within VBA? MSXML6 does not work with XPath 2.0.
Basically, I want to parse XML documents using XPath 2.0 as it allows me to use functions within the XPath expression to filter the XML document. As an example, the usage of the function current-date() would be useful as I would be able to retrieve data greater than a certain date. If I used XPath 1.0, I would need to arbitrary loop though the dates returned by the XPath and compare which dates were greater than a certain date.
Do you have any ideas as to how I could use XPath 2.0 within Excel 2003 VBA or any alternatives to my problem?
Thanks in advance for any help.
Donald