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.