| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macros works on one PC but not on another
Hi
click on the 10.0 one and see how that goes Paul |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Addin works that works on a template workbook | Excel Programming | |||
| it works, it doesn work, its works....and so on. | Excel Programming | |||
| How do I convert works file to excel without works software? | Excel Discussion (Misc queries) | |||
| weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
| Macros works in Excel 02 but not 97 | Excel Programming | |||
![ChrisMattock[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
