I have a tool created to track and auto up load large amounts of
information using VBA. The catch is that one of the people in the team
has upgraded to Excel 2007 and the library in VBA that is used in Excel
2003 is changed when the person with Excel 2007 gets into the tool.
The person using Excel 2007 is able to use all the functions of the
tool (because all the libraries are changed automatically) but when
they are finished and close the tool it keeps the new library. So when
the others that are using Excel 2003 go to use the tool it does not work
because they require a different version of the library.

The name of the library that keeps changing is “Microsoft Word 11.0
Object Library”. It changes to “Microsoft Word 12.0 Object Library”
when Excel 2007 is used to run the tool.

Is there a patch from Microsoft that will allow the tool to be used
between both releases (Excel 2003 and Excel 2007)?

Any help would be greatly appreciated.




--
Melinda Kliman