GopherUK
Active Member
- Joined
- Jan 23, 2009
- Messages
- 473
Hi Folks,
I have a workbook that I have used heavily in the past and just tried to open it on a new machine.
At startup, the workbook imports and parses an XML file. However, when opened, I get error 'Compile error: User-defined type not defined', highlighting the statement 'XMLDoc As MSXML2.DOMDocument' in a module.
Now, the thing to check would be VBA references. And that is the odd thing - the reference to Microsoft XML, v6.0 is already set. Additionally, IntelliSense is working for 'MSXML2', so I am a little lost here.
------------------------
Update: it seems this is a problem with Windows 8 XML 6.0 not exposing MSXML2. I have tried setting references back to XML 3.0 but every time I do that then reopen, the reference has changed back to XML 6.0
Can any one help?
I have a workbook that I have used heavily in the past and just tried to open it on a new machine.
At startup, the workbook imports and parses an XML file. However, when opened, I get error 'Compile error: User-defined type not defined', highlighting the statement 'XMLDoc As MSXML2.DOMDocument' in a module.
Now, the thing to check would be VBA references. And that is the odd thing - the reference to Microsoft XML, v6.0 is already set. Additionally, IntelliSense is working for 'MSXML2', so I am a little lost here.
------------------------
Update: it seems this is a problem with Windows 8 XML 6.0 not exposing MSXML2. I have tried setting references back to XML 3.0 but every time I do that then reopen, the reference has changed back to XML 6.0
Can any one help?
