Exel VBA Object Library problems between 2003 and 2007

T

TomF

Hi,

We are currently running some machines on Office 2003 and some with Office
2007. We have a business spreadsheet that contains VBA and are having
problems with switching the sheet between 2003 and 2007.

When the spreadsheet is saved in 2007, references are changed to "Microsoft
Excel 12.0 Object Library", "Microsoft Office 12.0 Object Library" and
"Microsoft Word 12.0 Object Library".

All the Macros work fine in 2007 and the problem comes when you try to open
the same sheet in 2003.

All the references change back to 11.0 appart from the Word one, which stays
at 12.0 (you get MISSING: Microsoft Word 12.0 Object Reference" when you look
at the references in the visual basic editor).

Does any one know of any way to fix this?

Thanks
 
A

Andrei Smolin [Add-in Express]

Hello,

You can switch to late binding (Dim WordApp as Object) and remove the Word
reference.

Regards from Belarus,

Andrei Smolin
Add-in Express Team Leader
www.add-in-express.com
 
Top