uftraining.blogg.se

Excel import xml dtd is prohibited
Excel import xml dtd is prohibited










excel import xml dtd is prohibited

I’ve found on the Internet that Office 2007 and older doesn’t prohibit DTD whatever that is. It appeared the file was supposed to be opened in Excel after all. I’ve discovered that the file may be supposed to be opened in Word, not Excel, but the Word 2013 gives me the same error.

excel import xml dtd is prohibited

The code I’m talking about is the following Set xmlDoc = CreateObject("Msxml2.DOMDocument.6.0") Is there some solution to just open the file without writing a program for it? And if not, what should I do with this code? Should I recite that code aloud before opening a file or what? Sorry, but I find it really absurd. I’ve searched for the solution, but all I found are some pieces of code that are supposed to solve the problem.īut I don’t get it at all! What code? I’m just opening the file, I’m not writing a program or anything. I’m trying to open an XML file in Excel 2013, but it says it can’t do that because “DTD prohibited”.












Excel import xml dtd is prohibited