Hi I have tried running my project to another computer both are using excel 2013. When I run the project on my laptop it works fine however when I try to run it in my friend's laptop it gives the compile error : Cannot find Project or Property.
This happens when the code in my thisworkbook (alerts the expired dates, see code below)
Private Sub Workbook_Open()usfrmlogin.show Dim LRow As Long Dim LResponse As String Dim lname As String Dim LFname As String Dim LDiff As Long Dim LDays As Long LRow = 2 LDays = 90 With Sheets("DataBase") While LRow < 200 If IsDate(.Range("Q" & LRow)) Then LDiff = .Range("Q" & LRow).Value2 - Date If (LDiff > 0) And (LDiff <= LDays) Then lname = .Range("B" & LRow).value LFname = .Range("C" & LRow).value LResponse = LResponse & lname & "," & LFname & "License will expire in " & LDiff & "days." & Chr(10) End If End If LRow = LRow + 1 Wend If CBool(Len(LResponse)) Then MsgBox "These Licenses are nearing expiration:" & Chr(10) & LResponse, vbCritical, "WARNING" End If End With End Sub
runs upon login and it displays a reference dialogue box after clicking ok. Then the word date is highlighted. I don't know if i should click/tick one of the choices and i don't know which one to tick. Does my friend need to install a missing library? Thank you in advance