Application OnTime...need some help to schedule.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wayliff - 19 Jan 2006 19:11 GMT

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

Reply to this Message

Dave Peterson - 19 Jan 2006 19:47 GMT

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.

> I'm having a problem usin the Applcation Ontime line in Excel VBA.
>
[quoted text clipped - 24 lines]
> wayliff's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29860
> View this thread: http://www.excelforum.com/showthread.php?threadid=503023

Signature

Dave Peterson

Reply to this Message