Compile Error - VBA

Posted by Richie Turner on June 27, 2001 3:27 AM

I have an Excel application that runs fine on every machine (97 and 2000) in the office except two where I get a compile error "Can't find Project or Library"

It falls down on a cmd_OKclick event and the following line of code is highlighted:

response = MsgBox("You haven't completed all the fields." & vbNewLine & _
"Click OK to complete the form or Cancel to abort creating a new job.", vbExclamation + vbOKCancel, _
"Form not completed")

If it means there is a certain file missing from these two machines, anyone know how I go about finding out what file is missing.

be very grateful for any help

thanks

Richie

Posted by Dax on June 27, 2001 3:34 AM

Richie,

The file for XL 2000 is called VBE6.DLL. You could also go into the VB Editor and click Tools, References and see if there is a reference to Visual Basic for Applications. It could be that the file exists on these machines but the reference is not set.

HTH,
Dax.