Excel Macro to automatically run a macro at certain time!

[sanilmathews]

Hi,

I need help in writing a macro which runs another macro at a certain time.

say for examble, I want macro1 to run automatically at "16:00:00".

Thanks in advance.

 

[ZPhantom]

[FONT=Arial]Private Sub Workbook_Open()[/FONT]
 [FONT=Arial]   Application.OnTime TimeValue("16:00:00"), "macro1"[/FONT]
[FONT=Arial]End Sub[/FONT]

 
 
S[FONT=Arial]ub MyMacro()[/FONT][FONT=Arial]    [/FONT]
[FONT=Arial]Application.OnTime   [/FONT]
[FONT=Arial]    TimeValue("16:00:00"), "macro1"[/FONT]
[FONT=Arial]'Put Code Here Please[/FONT]
End Sub


</PRE>

Course the workbook has to be open for this to work...

ZP

 

[Ruddles]

Course the workbook has to be open for this to work...

The workbook can be closed but Excel has to still be running. Excel will re-open the workbook to run the MyMacro if necessary.

MyMacro has to be in a standard code module.

 

[ZPhantom]

well played Sir, I stand corrected.

 

[Ruddles]

Yeah, that caught me out the first time I tried using OnTime inside Workbook_Open. Every time I tried to close the workbook, it kept re-opening itself!

 

[sanilmathews]

Thanks.