Hi there.
Really do hope someone here can give me a hand here. I'm building an Excel application (VBA driven) that consumes data from a webservice.
I'm using objects from the MSXML4.0 library, to manipulate the resultsets returned by the webmethods..
Most of the resultset is in the form of a IXMLNodeList..
Let's say I wanna do some kinda filtering to the resultset, and retrieve out all nodes, with the column 'DateCreated' within a certain date range.. How do I achieve this? I know I'm gonna have to use XPath query(using .selectNodes() method).. But I'm not too verse in that area.. ANy help here would be much appreciated!!
Really do hope someone here can give me a hand here. I'm building an Excel application (VBA driven) that consumes data from a webservice.
I'm using objects from the MSXML4.0 library, to manipulate the resultsets returned by the webmethods..
Most of the resultset is in the form of a IXMLNodeList..
Let's say I wanna do some kinda filtering to the resultset, and retrieve out all nodes, with the column 'DateCreated' within a certain date range.. How do I achieve this? I know I'm gonna have to use XPath query(using .selectNodes() method).. But I'm not too verse in that area.. ANy help here would be much appreciated!!