using Office 12 MSWORD.OLB on maching running Office 10

[Ed Sowell]

When I try to install a Excel/VBA project developed on a Vista machine with
Office 12 on an XP machine running Office 10
it successfully finds everything except MS Word object lib. I then looked
at a older version that
I originally developed on XP\Xl2003 and saw that it was using MS Word 10 Obj
Lib which maps to C:\program Files\Microsoft\Office10\MSWORD.OLB. So I tried
checking that in the VBE References dialog. No joy. It still insisted it
needed MS Word 12, which it again labeled as Missing. But, I found that XP
does have a C:\program Files\Microsoft\Office12 directory, albeit without
MSWORD.OLB. So I copied MSWORD.OLB from my Vista Office12 directory over the
the XP Office12 directory, and it works!

Still, I feel a bit uneasy about this. My gut feeling is there is no reason
my code should not work entirely under XP/Xl2003. While I have aded a lot of
code since moving to my Vista machine, my coding style has not changed and I
have not added any bells and whistles so far as I know. And, if were truely
OK to be using Office12\MSWORD.OLB with Xl2007 under Vista, why doesn't
Miscrsoft put it there?

BTW, I was referred to this newsgroup from the Excel programming group since
it is a Word library that's missing.
My app uses Word Mailmerge to generate mailing labels.

Ed

 

[Jonathan West]

When I try to install a Excel/VBA project developed on a Vista machine
with Office 12 on an XP machine running Office 10
it successfully finds everything except MS Word object lib. I then looked
at a older version that
I originally developed on XP\Xl2003 and saw that it was using MS Word 10
Obj
Lib which maps to C:\program Files\Microsoft\Office10\MSWORD.OLB. So I
tried
checking that in the VBE References dialog. No joy. It still insisted it
needed MS Word 12, which it again labeled as Missing. But, I found that XP
does have a C:\program Files\Microsoft\Office12 directory, albeit without
MSWORD.OLB. So I copied MSWORD.OLB from my Vista Office12 directory over
the
the XP Office12 directory, and it works!

Still, I feel a bit uneasy about this. My gut feeling is there is no
reason
my code should not work entirely under XP/Xl2003. While I have aded a lot
of
code since moving to my Vista machine, my coding style has not changed and
I
have not added any bells and whistles so far as I know. And, if were
truely
OK to be using Office12\MSWORD.OLB with Xl2007 under Vista, why doesn't
Miscrsoft put it there?

BTW, I was referred to this newsgroup from the Excel programming group
since it is a Word library that's missing.
My app uses Word Mailmerge to generate mailing labels.

Ed

Hi Ed.

First, you are probably breaking some kind of licensing restriction by
moving the file across. Second, the combination of the Office 12 MSWORD.OLB
with Office 10is such an odd combination that I would very much hesitate to
suggest that it is in any way reliable.

What you need is a reliable solution to work on office 10 (office XP) and
fortunately, a solution is at hand.

Take the Excel files containing the code and open them on an Office XP
machine. In the VBA editor, go to Tools, References, and ensure that the
references are set correctly to the Office 10 version of MSWORD.OLB. Save
the files.

Now, use those files to distribute to both Office 10 and Office 12 machines.
When a newer version of MSWORD.OLB is found, than the one listed on the
references list, it will be attached automatically, and provided you aren't
tripped up by differences in the object models between the learlier and
laters versions of the apps, all should be well.