PDA

View Full Version : Solved: Compile Error - Project or Library Not Found



allison
03-03-2008, 02:45 PM
This code works just fine for me, but when someone else runs it, they are getting a compile error - project or library not found:



Sub Save()
Dim newFile As String
Dim faName As String
Dim fbName As String

Application.ScreenUpdating = False

faName = Range("H2").Value
fbName = Range("H4").Value

newFile = Format$(Date, "YYYYMMDD") & " " & faName & " " & fbName

ChDir "E:\"
ActiveWorkbook.SaveAs Filename:=newFile

MsgBox ("Review logged as " & newFile)

Application.ScreenUpdating = True

End Sub


I have checked/rechecked that the people that are trying to run it have permissions to read/write into the folders, etc. Any suggestions?

Bob Phillips
03-03-2008, 03:00 PM
Go to the VBIDE on their machine, menu Toole>References, and you will see an item in the list checked with MISSING next to it. Go back to your machine and remove the reference to that library, it is likely not needed, and then pass it on again.