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


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


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

thanx


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements