MISSING: Microsoft Word 11.0 Project Library
 

Morning all, having some problems with an excel sheet that I have made
on my laptop and brought into work and when I try and run any of the
macros it comes up with....

Compile Error:

Can't find project or library

I opened Tools = References and found that on the work machine I
have:

MISSING: Microsoft Word 11.0 Project Library

With Microsoft Word 10.0 Project Library being present amoungst others,
any suggestions as to how to rectify this?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile: http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=541502

MISSING: Microsoft Word 11.0 Project Library
 

The easiest way to deal with this is through early binding, which means you
don't specify a Word version, you don't set a reference, you don't have the
nice intellisense in the VBE, but it works no matter which modern version of
Excel is installed.

http://peltiertech.com/Excel/EarlyLateBinding.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"ChrisMattock"
wrote in message
news:ChrisMattock.27oyqo_1147432214.5129@excelforu m-nospam.com...

Morning all, having some problems with an excel sheet that I have made
on my laptop and brought into work and when I try and run any of the
macros it comes up with....

Compile Error:

Can't find project or library

I opened Tools = References and found that on the work machine I
have:

MISSING: Microsoft Word 11.0 Project Library

With Microsoft Word 10.0 Project Library being present amoungst others,
any suggestions as to how to rectify this?


--
ChrisMattock
------------------------------------------------------------------------
ChrisMattock's Profile:
http://www.excelforum.com/member.php...o&userid=33912
View this thread: http://www.excelforum.com/showthread...hreadid=541502