HELP! I want to start a macro at a certain time

  • Thread starter Thread starter Joerg
  • Start date Start date
J

Joerg

Hi,

I really need help. I want to start a Excel macro at a certain
predetermined time. At that time I will not be at the computer. Does
anybody know how to do that?

Thanks a lot

Bye Joerg
 
You can also use the Ontime function

This example runs my_Procedure 15 seconds from now.

Application.OnTime Now + TimeValue("00:00:15"), "my_Procedure"

This example runs my_Procedure at 5 P.M.

Application.OnTime TimeValue("17:00:00"), "my_Procedure
 
Back
Top