View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default object library or invalid reference

Perhaps somehow a wrong version reference has been picked up, can't think
how though. Maybe compare a list of reference details returned on Excel 2007
machines that do/don't work. Might have to run the following in a different
wb. User might need to allow the trust access to vb project setting.

Sub RefDetails()
Dim p As Long
Dim wb As Workbook
Dim rf As Object

Set wb = ThisWorkbook
'Set wb = Workbooks("myFile.xla/s")
For Each rf In wb.VBProject.References
With rf
p = InStrRev(.fullpath, "\")
Debug.Print .Name, _
Mid$(.fullpath, p + 1, 12), _
.major & "." & .minor, _
.GUID
End With
Next

End Sub




"Bob Flanagan" wrote in message
. ..
I have an add-in that on one user's PC is saying office library invalid or
contains invalid references when it is executed. However, in Tools,
References, all is fine. None are missing. All references are the same

as
another add-in which works fine. I've rebuild the add-in with the code
cleaner and the max number of lines is 509, and the add-in is quite small.

The user is using Excel 2007, but it works on other 2007 machines.

Any thoughts?

Bob