Hier ist die Lösung...
08.09.2016 11:40:21
Jonny
' Code in DieserArbeitsmappe
Option Explicit
Private Sub Workbook_Open()
Const cClosingTime = "07:57"
dCloseTime = Date _
+ IIf(Time > CDate(cClosingTime), 1, 0) _
+ TimeSerial(Hour(cClosingTime), Minute(cClosingTime), Second(cClosingTime))
Application.OnTime EarliestTime:=dCloseTime, Procedure:="SpeichernSchliessen"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
If dCloseTime > 0 Then
On Error Resume Next
Application.OnTime EarliestTime:=dCloseTime, Procedure:="SpeichernSchliessen", Schedule: _
=False
dCloseTime = 0
End If
End Sub
' Code im Module
Option Explicit
Public dCloseTime As Double
Sub SpeichernSchliessen()
ThisWorkbook.Close SaveChanges:=True
dCloseTime = 0
End Sub