View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Workbook code works on my machine but noy others

Sometimes excel doesn't recognize the reference libraries and you had to
browse for the librarry file even though it appears to be correct. This
happens often with the Ref Edit Control in particular but can happen with
other libraries.

"Jacob Skaria" wrote:

All user machines need to have the same version of references..In one of the
machines which return the error check VBEToolsReferences to see which one
is missing in that machine..

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

Hi,

I've got a Workbook i distribute to users. For some reason the WB is
crashing only with some of my users. I get the error
"Object Library Invalid or contains references to object definitions
thatcould not be found"

I've checked the reference ticked in VBE which a

Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Windows Common Controls-2 6.0 (SP6)
Microsoft Outlook 10.0 Object Library
Microsoft Windows Common Controls 6.0 (SP6)

Weird as the application works ok on some machines but not other
Any ideas on this are very welcome.
Thanks guys,
John