ich habe dieses Macro von einem Excel-Sheet übernommen. In der neuen Datei funktioniert dieses Macro nicht mehr. Kann mir jemand sagen wieso?
Danke
Sub tageslauf()
' heute = today()
Windows("datenbasis.xls").Activate
Sheets("Sheet1").Activate
v_pos = Sheets("Sheet1").Range("T2").Value
If Not IsError(v_pos) Then
Sheets("Sheet1").Cells(v_pos, 1).EntireRow.Select
Selection.Interior.ColorIndex = xlNone
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
ActiveSheet.Cells(v_pos, 1).Select
ActiveSheet.Cells(v_pos, 20).Value = Now
ActiveWorkbook.Save
Beep
Else
Beep
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 1
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
Beep
newHour = Hour(Now())
newMinute = Minute(Now())
newSecond = Second(Now()) + 1
waitTime = TimeSerial(newHour, newMinute, newSecond)
Application.Wait waitTime
Beep
End If
' MsgBox v_pos
datenbasis_zeitsteuerung
End Sub
Sub datenbasis_zeitsteuerung()
Application.OnTime TimeValue("14:33:00"), "tageslauf"
End Sub