Excel: Object Library Switching from 2000 to XP

I have an Excel workbook that was written with Excel 2000 that has references to, among others, Microsoft Word 9.0 Object Library. When the workbook is opened and saved with Excel XP, all 9.0 object library references change to 10.0. When the book is reopened in 2000 all references change back to 9.0 except the Word library, which causes a MISSING: Microsoft Word 10.0 Object Library error.

Using

ThisWorkbook.VBProject.References.AddFromGuid "{00020905-0000-0000-C000-000000000046}", 1, 0

to programmatically call the Word object library in the ThisWorkbook object works, but if an XP user saves the workbook it still causes the MISSING error for 2000 users. Plus, since VBA was changed, my digital certificate is dropped and everyone has to enable macros again.

To eliminate this problem I changed

Dim wdObj As Word.Application
Set wdObj = New Word.Application

to

Dim wdObj As Object
Set wdObj = CreateObject("Word.Application")

but now I don't have access to Word's formatting abilities.

I'm sure I could create a Word template and replace placeholders, but I'd prefer to generate the entire document on the fly. I'm hoping there's a way around this problem. Any ideas?

Thanks in advance.
Dave Kazebeer

U can copy the dll file(Microsoft Word 10.0 Object Library) to system directory of the pc using office2000,and run regsvr32 to register it..And copy the dll file (Microsoft Word 9 Object Library) to system directory of the pc using office2000,and run regsvr32 to register it....Maybe it's effective!

I'll see if that works. There are a bunch of 2000 machines; do you know of any way to automate that process that wouldn't require admin/IT involvement?

It's a way to make a install program to copy and register the two dll file(Microsoft Word 10.0 Object Library and Microsoft Word 9 Object Library) in the system...