Problems with ONTIME

[snorky]

Hello All,
I have written an Excel add-in that uses Application.ontime to schedule a future run of a macro. This works fine as long as the time doesn't exceed 24hrs. If, say,it's Friday and I want to run the macro on Monday ,I start my program and it sits and waits till Saturday and then runs the macro at the correct time but the wrong DAY ???? Any ideas , is this a limitation of application.ontime ?

Thanks Snorky

 

[xlbo]

Why not do a test to see what the current day is (Worksheetfunction.weekday)
If weekday <> Friday then
wait 24 hours
else
wait longer
end if

HTH Rgds
~Geoff~

 

[snorky]

Thanks for the idea . I had hoped that the ontime function would work like that , but it seems that I'll have to code my way round this . Thanks anyway !

Snorky