M
Melinda Kliman
I have a tool created to track and auto up load large amounts o
information using VBA. The catch is that one of the people in the tea
has upgraded to Excel 2007 and the library in VBA that is used in Exce
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 th
tool (because all the libraries are changed automatically) but whe
they are finished and close the tool it keeps the new library. So whe
the others that are using Excel 2003 go to use the tool it does not wor
because they require a different version of the library.
The name of the library that keeps changing is “Microsoft Word 11.
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 use
between both releases (Excel 2003 and Excel 2007)?
Any help would be greatly appreciated
information using VBA. The catch is that one of the people in the tea
has upgraded to Excel 2007 and the library in VBA that is used in Exce
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 th
tool (because all the libraries are changed automatically) but whe
they are finished and close the tool it keeps the new library. So whe
the others that are using Excel 2003 go to use the tool it does not wor
because they require a different version of the library.
The name of the library that keeps changing is “Microsoft Word 11.
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 use
between both releases (Excel 2003 and Excel 2007)?
Any help would be greatly appreciated