Compile Error: Can't find project or library

[TFCJamieFay]

Hi All,

I have a workbook that is used by a number of different users accross the company. Some people have PC's running Windows 2003 SP3, some have terminals with either
- Windows 2000 SP4 with Excel 2002 SP3
or
- Windows 2003 SP2 with Excel 2002 SP3
on the server.

On the "Windows 2003 SP2 with Excel 2002 SP3" example the code below won't run. Saying "Compile Error in hidden module." I unlocked the code and re-ran the "Workbook_Open" event but I keep getting "Compile Error: Can't find project or library". I have then checked the references but none have the "Missing" prefix, so I don't know which to look for. Does anyone know what DLL i need to load or should I just get IT to updgrade to SP3?

Many thanks,

Jay

Private Sub Workbook_Open()

    Dim MyName As String
    
    'Sets the MyName variable to the users Username
    MyName = StrConv(Environ("username"), vbUpperCase)
    
    With Application
        .DisplayAlerts = False
        .ScreenUpdating = False
    End With
    
    'Decides which reports to show each user
    Select Case MyName
    End Select

    Call PopulateReportList
    
    With Application
        .DisplayAlerts = True
        .ScreenUpdating = True
    End With
    
End Sub

 

[TFCJamieFay]

I unlock the project and then I click on "Tools" > "References". Then I have scrolled through the list to look for any with a "Missing" prefix as it says in the help, but none in the list have this prefix. On a previous workbook it was "Refedit.DLL" that was missing, I've tried that one, but it doesn't work either.

Thanks,

Jay

 

[Jonmo1]

Next bess guess at troubleshooting would be to..

1. Save copy of file
2. Uncheck references one at a time

 

[Norie]

Jay

On which computer(s)/setup(s) are you checking the references?

Do you have any code that might add/delete references?

 

[Jonmo1]

On which computer(s)/setup(s) are you checking the references?

That's a good obvious point I missed Norie. Make sure you are checking for missing references on a computer that is having the problem. NOT on your pc.

 

[TFCJamieFay]

The problem is only on thin client terminals which use Windows 2003 SP2 and Excel 2002 SP3. My PC is Windows XP 2003 SP2, and I use Excel 2003 SP3. Other terminals on differnet servers using Windows 2000 SP4 and Excel 2002 SP3 work Ok, it's just the server running Windows 2003 SP2 and Excel 2002 SP3 that have the problems.

The thing I don't understand is that the two different servers use the same version of Excel (2002 SP3) but have different versions of Windows (2000 SP4 and 2003 SP2), it's the ones on Windows 2003 SP2 that doesn't work.

Jay

 

[Norie]

Jay

Are you going to tell us if you did check the references on a machine with the problem?

Or is it a secret.

I don't really know much about servers, service packs etc but I've never heard of them causing such problems.

Perhaps you should be speaking to your IT guys.

 

[Jonmo1]

OK, so the question again...

Which computer are you sitting at when you check Tools - References??

 

[TFCJamieFay]

Sorry!

I was always checking it on the 2003 machines, but none had the "Missing" prefix. I'll speak to IT then.

Thanks for your help though guys!

Jay

 

[Norie]

Jay

So you are checking the references on the machines the code works on?

You should be doing that on machines where the problem is happening.

 

[TFCJamieFay]

No, I've been checking it on the machines with the problems, but none seem to say which are "Missing". Don't worry, about it. I'll speak to our IT guys and see about upgrading to Windows 2003 SP3.

Thanks Guys.

Jay