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

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