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

--
waylif
-----------------------------------------------------------------------
wayliff's Profile: http://www.excelforum.com/member.php...fo&userid=2986
View this thread: http://www.excelforum.com/showthread.php?threadid=50302