Macros works on one PC but not on another

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 don't think it makes a difference but one macro opens up a word document and adds cell information to bookmarks in it, the other spells a number (i.e. 200 becomes TWO HUNDRED)... neither see to work, same message for both.

Hi
On the other machine open up the VB Editor and go to Tools, References.
Look for any references with MISSING next to them. It might be, for
example, that your laptop is referencing the Word 11.0 Object Library
but the other machine has Word 10.0. You would then need to click on
the reference to Word 10.0 on the other machine.

regards
Paul

Thanks you are indeed correct, MISSING: Microsoft Word 11.0 Project Library, the Microsoft Word 10.0 Project Library is there though, how do I rectify this situation?

Click on the Browse button and navigate to (typically)
"C:\Program Files\Microsoft Office\\OfficeMSWORD.olb") for Word
and "C:\Program Files\Microsoft Office\Office\MSPRJ.olb" for
Project/


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"ChrisMattock"
<[email protected]> wrote
in message
news:[email protected]...
>
> Thanks you are indeed correct, MISSING: Microsoft Word 11.0
> Project
> Library, the Microsoft Word 10.0 Project Library is there
> though, how
> do I rectify this situation?
>
>
> --
> ChrisMattock
> ------------------------------------------------------------------------
> ChrisMattock's Profile:
> http://www.excelforum.com/member.php...o&userid=33912
> View this thread:
> http://www.excelforum.com/showthread...hreadid=541454
>

Assuming there is no way round that? Apparently I don't have access to the browse button... access rights. I suppose just redoing all my work on the work cmoputer may be the only way :S

Hi
click on the 10.0 one and see how that goes

Paul

No that didn't work, but don't worry I've solved the problem... kind of...
I just copied and pasted the code and worksheets from the saved verion to a new version using the older excel. Seemed to work, not the most elegant solution, but a solution is a solution! :P