Dear Expert,
I asked for this question before.
Someone asked me to refer to this path.
http://www.brainbell.com/tutorials/m...A_Set_Time.htm
I did it ....
I even tried to prepare similar marco in my Excel.
Save these 2 macros in a file called TimeMarco.Xls
The scripts (task) is meaningless ... Just type as a test.
I open this file TimeMarco.xls
But it works sometimes ... it does not work sometimes ....
I am using Excel 2000.
How I can make it work all the time ?
Thanks ...


Private Sub Workbook_Open()

Application.OnTime TimeValue("19:13:40"), "MyMacro"

End Sub

Sub MyMacro()

Application.OnTime TimeValue("19:13:40"), "MyMacro"

Application.Goto Reference:="R1C1"
ActiveCell.FormulaR1C1 = "I love you"
Range("A1").Select
Selection.Copy
Range("A2:A18").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("C1").Select
ActiveCell.FormulaR1C1 = "I hatee you"
Range("C1").Select
Selection.Copy
Range("C2:C11").Select
ActiveSheet.Paste
Application.CutCopyMode = False
Range("E1").Select
ActiveCell.FormulaR1C1 = "I look €¦€¦€¦"
Range("E2").Select

End Sub