Load XML With Msxml.dll References

We've developed some Excel spreadsheets which load in XML data from the web and then parses through it.

Dim oDoc As MSXML.DOMDocument
Dim fSuccess As Boolean
Dim oRoot As MSXML.IXMLDOMNode
Dim oTimeProperty As MSXML.IXMLDOMNode
Dim oAttributes As MSXML.IXMLDOMNamedNodeMap
Dim oChildren As MSXML.IXMLDOMNodeList
Dim oChild As MSXML.IXMLDOMNode
Dim oOpChildren As MSXML.IXMLDOMNodeList
Dim oOpChild As MSXML.IXMLDOMNode

To do this we add "Microsoft XML, version 2.0" in the " References" menu (which is from C:WindowsSystem32msxml.dll). This works fine on Windows XP and 2000 but Windows Vista doesn't have msxml.dll so it doesn't work. I've searched the web and found a page recommended using msxml6.dll as a direct alternative but unfortunatly the VBA script fails when implementing the MSXML object.