Xml in Excel/VBA

Hi
I developed an application in excel2000 which gets info from an xml file on a Tomcat server. The xml comes back and is loaded into a domdocument and is then parsed and load into a spreadsheet. The problem is I need to run the spreadsheet in excel97, I've transferred all the code over exactly and now the app does not work. When the xml comes back it is not getting loaded into the domdocument and therefore making the app fall over at this point.

Any ideas or suggestions

Check the XML Parser version installed on the Office 97 machine?

Yes I checked that and they are both identical versions. I've tried the same excel2000 spreadsheet on another machine with Windows2000 and Office2000 and it doesn't work there either, completly lost.