I need to change/set the xmlreadersettings property to ignore so that I can import xml documents into Excel 2013.
I have searched high and low and cannot find a vba solution.
I have set a referece to Microsoft XML, v.6.0
XmlReaderSettings readerSettings = new XmlReaderSettings(); readerSettings.DtdProcessing = DtdProcessing.Ignore
Dim DtdProcessing as Dtdprocessing
System.XML.DtdProcessing.Ignore
Dim settings As XmlReaderSettings = new XmlReaderSettings()'
settings.IgnoreProcessingInstructions = True
I get a user defined type not defined error highlighting the red text.
Does a VBA solution exist?
Bookmarks