View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Workbook code works on my machine but noy others

Just try browsing the control again if it is available in that machine...

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


"John" wrote:

Hi Jacob,

intersting comment!! I did notice that one of the references was version 3
on mine and version 2 on the users. Guess from what you're saying this can
make a difference.
So a follow up question is, would i need to uncheck it and then add it again?

Thanks
Regards,
John

"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