Application OnTime...need some help to schedule.

[wayliff]

I'm having a problem usin the Applcation Ontime line in Excel VBA.

I'm probably using it ok but I am missing something.

The purpose is to run a procedure each day at say 7AM even if excel i
not open and even if the computer is not on.
I can turn on the computer using the Windows Task Scheduler so tha
should not be a big deal.

In vba

I created an independent routine to just call the main macro each da
at 7PM.

sub()
Application.OnTime Time("07:00", "macro1")
End Sub

This seems to work when I run the sub and wait for it to actuall
run...then it happens but the macro does not run if I turn off excel.

Help appreciated

 

[Dave Peterson]

Excel has to be running and the .ontime macro has to be set.

Maybe your task scheduler can just open that workbook and run the macro.

Name that macro auto_open so it runs when the workbook is opened.