I want to close down excel after 1 hour automatically

[blitzz]

I would like to close down excel after 1 hour automatically once it has been started: I have tried some timer loops, this does work, but has some side-effects. I had placed the loop into the workbook.activate respectively in the workbook.open routines, but its not the roght place there. Can it be done, elsewhere, or is there any other solution?

[Tom Ogilvy]

Look at Application.OnTime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"blitzz" wrote:

>
> I would like to close down excel after 1 hour automatically once it has
> been started: I have tried some timer loops, this does work, but has
> some side-effects. I had placed the loop into the workbook.activate
> respectively in the workbook.open routines, but its not the roght place
> there. Can it be done, elsewhere, or is there any other solution?
>
>
> --
> blitzz
> ------------------------------------------------------------------------
> blitzz's Profile: http://www.excelforum.com/member.php...o&userid=34078
> View this thread: http://www.excelforum.com/showthread...hreadid=538408
>
>

[blitzz]

Problem solved, Tom, I am most grateful. It is good to have control....