Using 2 timers, possible or not

[Diephoha]

Hi All,

I got the following code:
Private Sub Workbook_Open()

Application.OnTime Now + TimeValue("00:02:00"), "SaveThis"

Application.OnTime TimeValue("23:43:00"), "CopyWorkbook"

End Sub

The first line runs every 2 minutes and that works.
Then at a specific time another macro should run at 23:43 but it doesn't.
Is it possible to have 2 timers running at the same time?
If not, what else can i do to make it run?

 

[mole999]

do you monitor the timestamps of the 2 minute operations, though it will be pretty reliable, how much do they drift

 

[Diephoha]

Hi Mole999,
I did monitor it by looking at the time stamp on the files.
The 2 minute macro "savethis" runs well and when i look at the timestamp i can see it has updated with 2 minutes, so far so good.
When i wait for the clocktime of the second line to run macro "copyworkbook" it never runs it. When i look at the timestamp it never changes.

So i am wondering if it is possible to run these 2 lines together or does it only run the first one and never the second one because the first is actively running?

 

[mole999]

i'm not totally hopeful, what happens if you swap over the two procedures so the copy is listed first

 

[Diephoha]

By changing the order it seems to work.
Mybe it is because a timer runs all the time so blocking the next line.
And the one with the clocktime only checks the systemtime and if its time it runs the macro, i imagine.

Thank you for pointing me in the right direction.

 

[mole999]

> Pearson Software Consulting worth reading, especially about cancelling timers