How to ignore a XML namespace in VBA



I have an XML file and this XML file has namespaces declared



<CrystalReport  xmlns="urn:crystal-reports:schemas:report-detail"  xmlns:xsi="http://ift.tt/ra1lAU" xsi:schemaLocation="urn:crystal-reports:schemas:report-detail http://ift.tt/1f27EiL">


This is causing problems in my VBA code in Excel. When I remove the namespaces of this line above, it works fine.


My question is: How can I ignore this namespace without have to open the xml file and remove manually?


Cheers.


No comments:

Post a Comment

Subscribe to: Post Comments (Atom)