Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
object library or invalid reference
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
object library or invalid reference
What references are you using?
"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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
object library or invalid reference
VB for applications
Excel object library OLE automation Office forms library Bob "Charles Williams" wrote in message ... What references are you using? "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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Object library Invalid | Excel Programming | |||
Object library Invalid | Excel Programming | |||
How do I add a reference to an object library using VBA? | Excel Programming | |||
Reference to Office 11.0 Object Library | Excel Programming | |||
object library invalid | Excel Programming |