Application.OnTime TimeValue

[Olyn01]

Hi everyone. I have this command "Application.OnTime TimeValue" on my workbook while it is open. I just like to know if that command will continue it's assigned task based on the time given on everyday basis or just the day that the workbook is open? Thanks

Application.OnTime TimeValue("09:00:30"), "RecordData"
Application.OnTime TimeValue("00:02:00"), "SaveThis"
Application.OnTime TimeValue("23:59:15"), "Copy_Fix"
Application.OnTime TimeValue("23:59:30"), "Copy_Fix_2"
Application.OnTime TimeValue("23:59:45"), "SaveAs"
Application.OnTime TimeValue("23:59:55"), "ClearCellsData"

 

[JoeMo]

Unless you have a specific event macro like Workbook_BeforeClose that sets the Schedule argument of the OnTime Method to false, once started the OnTime procedure will run daily.

 

[Olyn01]

Unless you have a specific event macro like Workbook_BeforeClose that sets the Schedule argument of the OnTime Method to false, once started the OnTime procedure will run daily.

That is what I knew before, but suddenly the code only works for a day then it won't the next day. I was actually talking about the Application.OnTime TimeValue("23:59:45"), "SaveAs". Before, I can leave the file open and let the codes to work, but suddenly I don't know what happen It requires reopening the file to make it work that day. Btw, Thank you for answering.

 

[RoryA]

It will only be scheduled once unless the called routines reschedule themselves.