The web based Excel workbook contents are accessed using XML DOM (document object). The contents of the web page are parsed into an XML DOM object using the MSXML api within VBA. The library used for ...

This paper solves the problem of the excessive memory footprint and the slow speed of parsing when using the DOM method to parse the XML data. As we know the current XML parsing technology is the key ...