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.



wayliff wrote:

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 is
not open and even if the computer is not on.
I can turn on the computer using the Windows Task Scheduler so that
should not be a big deal.

In vba

I created an independent routine to just call the main macro each day
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 actually
run...then it happens but the macro does not run if I turn off excel.

Help appreciated.

--
wayliff
------------------------------------------------------------------------
wayliff's Profile: http://www.excelforum.com/member.php...o&userid=29860
View this thread: http://www.excelforum.com/showthread...hreadid=503023

--

Dave Peterson