Macro to Close Excel Program at specific time of day

[Cremorneguy]

Hi there,

I need a macro that will close an excel file at a specific time of day (i.e. 7pm). I can't use the 'Task Scheduler' on my work PC, it has a restriction on it, therefore I need to insert a macro to have the file automatically close at 7pm at night.

Can anyone provide me with this type of macro?

Thanks

[sktneer]

You may try something like this....

Place the following code on ThisWorkbook Module...

Please Login or Register  to view this content.

Now on a Standard Module (Insert a new module), place the following code...

Please Login or Register  to view this content.

[Cremorneguy]

Hi sktneer,

Thats great, it does work, however is there something that will close excel itself, the workbook closes but excel itself remains open.

[sktneer]

Replace the second sub-routine with the following one.....

Please Login or Register  to view this content.

[EssoExplJoe]

The workbook open event only fires when the workbook is opened and won't close at the specific time unless it is opened then. You might try a Wscript file running in the background that occasionally loops to check the time. The Wscript can then close the workbook at the appropriate time.