object library or invalid reference

[Bob Flanagan]

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

 

[Charles Williams]

What references are you using?

 

[Bob Flanagan]

VB for applications
Excel object library
OLE automation
Office forms library

Bob

 

[Peter T]

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