VBA to run Macro at a specific time

[okcheung]

Dear all,
I need a code to check the time now to run another procedures in a specific time (say 15:00, I need to run Auto_Update, and in 16:00, I need to run another called "Check_Data").
Anyone got the code so that I can make reference to?


Andrew

 

[Lewiy]

You need to use:

Application.OnTime TimeValue("15:00:00"), "Auto_Update"
Application.OnTime TimeValue("16:00:00"), "Check_Data"

Put these lines in a seperate macro and run it straight away. Your code will fire at the selected times.

 

[okcheung]

Thanks Lewiy, but I need a code that will run automatically when the workbook is kept open. Any idea?

 

[Lewiy]

If you put that code in the Workbook_Open event then it will trigger when you open the document. When it reaches the time specified, it will trigger your macros as you asked. All done automatically.

 

[okcheung]

Actually I will keep my workbook open and will not close, so how can i do that so it would check existing time with the specified time, and run the program if the time is matched?

 

[Lewiy]

Something would have to trigger the code in the first place, you can only trigger by time within another Sub which would have to be started at some point. I’m not 100% sure but I think once you run it once and keep the workbook open at all times, it will continue to run every day at the desired time. So all you have to do is run the initial code once.