Ontime - Run At given date and time

[saravnepali]

I have to submit report at different times.

So, I have one program to submit report

Now, I have a list of date & time I want to submit the report.

How do I make excel look at the list of time and run the programme as appropriate.

Sub report_submit ()
'look at the range values on sheet1 Range A1:A5 of this workbook

2/11/2020 07:30
3/11/2020 07:30
6/11/2020 07:30
9/11/2020 07:30
12/11/2020 07:30


'If current time is as per the list run / call the sub - Submit_Report

end sub

The challange is syntax for ONtime needs earliest time, how do we feed it the time that we want the report to run

And if we make excel to run it now (say on how say
2/11/2020 07:30) to prepare excel to keep looking for next possible timing given that the frequency of the report to be submitted is not constant

Any help will be appreciated.

[6StringJazzer]

You make a call to OnTime for each of your times. Then you must leave Excel open the entire time for the sub to be called on the appropriate day/time. The reason that the documentation says "earliest time" is that a software application that depends on the operating system to provide the time and interrupts cannot guarantee that it will be exactly at that time, but it will be so close you won't be able to tell the difference. (Real-time embedded applications run on bare metal so they have absolute control over timing. Windows on a PC, not so much.)

If current time is as per the list run / call the sub - Submit_Report

If you try to program this yourself instead of relying on OnTime you have the challenge of constantly checking to see if it's time to run, and then making a note that it has already run so it doesn't do it twice for the same time.