How to change the xmlreadersettings property?

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

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I get a user defined type not defined error highlighting the red text.

Does a VBA solution exist?

Please post the entirety of your code that looks like a combination of vb.net and c#, neither of which will work in vba.

Kyle,

The code is VBNet. I am trying to find a VBA equivalent because the above code obviously doesn't work.

Basically, I need to import XML files into either Access or Excel.
I cannot import the XML files because of a 'DTD prohibited error'. I read that by changing the xmlreadersettings (OR Dtdprocessing settings?) to ignore this will fix the issue.

My knowledge is not advanced enough to know how to achieve this.

So, the code that I need is simply to change the settings to ignore. Should only be one line I presume, as above, obviously with the correct reference.

Any ideas?

Could you post the code that you're using to import the xml, since you've got the reference ticked, I'm assuming that you're doing this through vba?

Yes I am importing the XML files through VBA, but obviously it doesn't work. Works without any problems in versions of Excel up to 2007.

Please Login or Register  to view this content.

First 3 lines of the XML files.

Please Login or Register  to view this content.

You may have to parse them manually in that case then using the MSXML library.
As an example:

Please Login or Register  to view this content.

Taken from: http://stackoverflow.com/questions/3...l-files-in-vb6

Thanks Kyle. Much appreciated.

I will play around with it and see if I can get it to work.