application.on time runs twice next day!!!

[gokzee]

Hello!!,

Sub Timer()
Application.OnTime TimeValue("12:08:00"), "a"
Application.OnTime TimeValue("12:10:00"), "b"
End Sub

Sub a()
Workbooks.Open Filename:="Z:\abcd"
End Sub

Sub b()
Workbooks.Open Filename:="Z:\efgh"
Call Timer
End Sub

my problem is using the macro..the day i run the macro..it works well...

but next day it will try to open the workbook twice...so error pops up asking do u wana open the file again...ths process stops the automated work....

Sometimes it works well..sometimes it doesnt..i think it depends on what time of the day i start the macro...

any help will be much appreciated

Many thanks

Gokz

 

[gokzee]

Somebody pleaseeee help me!!!!