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.


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

Macros works on one PC but not on another
 

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

Macros works on one PC but not on another
 

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

Macros works on one PC but not on another
 

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"
wrote
in message
news:ChrisMattock.27orsm_1147423203.0189@excelforu m-nospam.com...

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

Macros works on one PC but not on another
 

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


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

Macros works on one PC but not on another
 

Hi
click on the 10.0 one and see how that goes

Paul

Macros works on one PC but not on another
 

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


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