you could use windows task scheduler to open the workbook, you will need to put the macro in the work book code,
Private Sub Workbook_Open()
'enter code here
ThisWorkbook.Close SaveChanges:=True
End Sub
note you will need to set macro security to low or it will ask to enable macros each time it opens