AW: Eingabe bei Application.Wait Now
18.06.2009 21:26:58
Josef
Hallo Gisela,
das geht zB. so. (achte darauf, welcher Code wohin gehört!)
' **********************************************************************
' Modul: DieseArbeitsmappe Typ: Element der Mappe(Sheet, Workbook, ...)
' **********************************************************************
Option Explicit
Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopTimer
End Sub
' **********************************************************************
' Modul: Modul1 Typ: Allgemeines Modul
' **********************************************************************
Option Explicit
Public RunWhen As Double
Public Const cRunIntervalSeconds = 10 ' Intervall in Sekunden - Anpassen
Public Const cRunWhat = "CloseWB"
Sub StartTimer()
RunWhen = Now + TimeSerial(0, 0, cRunIntervalSeconds)
Application.OnTime earliesttime:=RunWhen, procedure:=cRunWhat, _
schedule:=True
End Sub
Sub CloseWB()
MsgBox "Das war's!" 'hier statt der MsgBox
'ThisWorkbook.Close True
End Sub
Sub StopTimer()
On Error Resume Next
Application.OnTime earliesttime:=RunWhen, _
procedure:=cRunWhat, schedule:=False
End Sub
Gruß Sepp