search

jpimbert / VBAToolKit

Toolkit for quality development with Excel VBA
149 stars 46 forks source link

Upgrading VBAToolKit for Excel 2013 #40

Open DarylMcCullough opened 9 years ago

DarylMcCullough commented 9 years ago

I'm trying to use VBAToolKit for the latest version of Excel, 2013. One incompatibility is that there is a more recent version of XML, "Microsoft XML v6.0". In this version of XML, there is no longer a public data type "DomDocument", but there is a "DomDocument60". I assume that it would be straight-forward to replace "DomDocument" everywhere in the VBA code by "DomDocument60", but I was wondering if anyone has tried doing that.

jpimbert commented 9 years ago

We can find some information here about that problem which is a Windows 8 issue.

A workaround is to use a previous version of Microsoft XML library. Try to use version 5.0 (In VBA Editor, select VBAToolKit project then, menu Tools->References).