Problem day 2 running a scheduled .xlsm-macro

[svenalgo]

I have a macro that should run every day at 07.00 o'clock from Windows schedule (Office 2007).
First day it runs perfect, next day it doesn't run at all.
If I look in Task Manager I see that EXCEL.EXE is running and
if I try to open my macro it says that the macro already running,
opened by myself. After restarting the computer it runs perfect again.
The first Sub in Modul1 is "Auto_open".
How to avoid restarting the computer every day?

[UKNinja]

Hi,

Reading this it sounds like the scheduled task opens the Excel workbook which triggers the macro stored in the Auto_Open routine to be ran, which means unless you exit the workbook after execution it won't be triggered again.

Try adding <code>Application.Quit</code> to the very end of the macro which will cause the Excel instance to terminate. The next time the scheduled task runs it will reopen the workbook and refire the macro.

[svenalgo]

Hi
I have already added "Application.Quit" as last sentence so the problem is in Windows Schedule
that not, as I think, close the instance correctly. Anyone that have a tips?!