macro

[madhan]

hi,
i have a problem i want to execute a macro on a particular time o
a day automatically

than

 

[mudraker]

Application.OnTime TimeValue("07:10"), "Name Of Macro Here

 

[Guest]

For example, you want to run the macro "my_Procedure" at 14.15, ...

Sub auto_open()
Application.OnTime TimeValue("14:15:00"), "my_Procedure"
End Sub

Sub my_Procedure()
MsgBox "hello"
End Sub

Regards,
Edwin Tam
(e-mail address removed)

----- madhan wrote: -----


hi,
i have a problem i want to execute a macro on a particular time of
a day automatically

thanx