Update to Excel 2013 - Broken VBA

[jimmisavage]

Hi,
I hope someone can help. I run a vba which sends email reminders when a date is approaching. This used to work a dream in Excel 2007 but work have upgraded to 2013 and now the VBA stops in it's tracks - It seems to highlight the word 'Date' on the IF statement:
If sDate <= Date - 14 Then
Ws.Cells(i, 5).ClearContents
Ws.Cells(i, 8).ClearContents
End If

The error is: Compile error: Can't find project or library

ActiveWorkbook.Sheets("Home").Activate
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
    .ScreenUpdating = False
    .EnableEvents = False
    .DisplayAlerts = False
End With
Sheets("mailpage").Visible = True
Sheets("mailpage").Select

Dim Ws As Worksheet
Dim LR As Long
Dim sDate As Date, fDate As Date
Application.ScreenUpdating = False
Set Ws = Worksheets("mailpage")
LR = Ws.Range("H" & Rows.Count).End(xlUp).Row
For i = LR To 2 Step -1
    sDate = Ws.Cells(i, 8).Value
    If sDate <= Date - 14 Then
        Ws.Cells(i, 5).ClearContents
        Ws.Cells(i, 8).ClearContents
    End If
Next i
Application.ScreenUpdating = True

 

[RoryA]

Check the references in the project (Tools - References in the VB Editor). One (or more) of them will be flagged as 'MISSING:'

 

[jimmisavage]

Check the references in the project (Tools - References in the VB Editor). One (or more) of them will be flagged as 'MISSING:'

Hi RoryA, thanks for the quick reply!
I have tried that but i'm getting another error: Error accessing the system registry.

 

[RoryA]

Did you stop the running code first? If so, I think a repair of the Office installation may be needed.

 

[jimmisavage]

Did you stop the running code first? If so, I think a repair of the Office installation may be needed.

Thanks Rory, I finally got around to sorting this. My work IT tried a repair install but the problem didn't go away. In the end i simply copied the code, saved to worksheet as a .xlsx, reopened, pasted the code back in and saved as .xlsm again - it works again now

 

[RoryA]

You can't have code in a workbook saved as xlsx format, so I'm confused.

 

[jimmisavage]

You can't have code in a workbook saved as xlsx format, so I'm confused.

Ha - I confused myself! I've edited my post, which should make sense now