Running a code at a specific hour wont work if...

Hello all,

I have a code inside "ThisWorkBook" module which calls another code in a specific time.
The problem is that if you are opening the workbook for the first time, the code wont run when the clock hits 04:19 am. This code only works if you have already manually ran the code at least once before. After you close and re-open the workbook, you get the same problem again.

The code is shown below:

Please Login or Register  to view this content.

Thank you all in advance, for attention and patience.
Joćo

Artik,

First of all thanks for replying.

I didnt understand why my code wont work if the workbook is opened before RunTime2.

Moving forward, I tested your code and it seems to work (thanks for that). Even though, it got me thinking: the code you wrote shouldnt make my code to run over and over forever? After 04:19, Time function will always be > than Runtime2. Why wont the macro run again after the first time it was ran then? On the second time, when Myworkbook module checks the if condition, Time will again be > than 04:19, agree?