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.
[ATTACH=CONFIG]68921[/ATTACH][ATTACH=CONFIG]68922[/ATTACH]
This happens when the code in my thisworkbook (alerts the expired dates, see code below)
Code
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
Display More
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