Great thank you so much, that working perfectly from what i asked. As a slight adjustment to my initial request, is there a way to just open the workbook with no message box when its before the expiry date. So to change this part?
PHP Code: 
Else
        MsgBox ("Opening file")
        Exit Sub
    End If