Ending Excel

[RobertHodges]

I am running an Excel program with Scheduled Task. I start it wit
Auto_open and it runs all my macros fine. The problem come when I en
(Quit), my entire task complete fine and clears leaving the MS Exce
task (shell). I tried using the end task in the Scheduled Task to en
the excel and it ends the excel but memory error dialog box. An
suggestion on how to end or run Excel program on a scheduler would b
appreciate

 

[jaf]

Hi Robert,
Do you have an exit routine? Does it use Application.Quit?
Post the code.

 

[RobertHodges]

I use the following

ActiveWindow.Close SaveChanges:=False


The spreadsheet has a addins that attactes to a API server, this may b
the problem

 

[jaf]

Hi Robert,
What your doing is closing the active workbook not the application. This
will leave an empty Excel window open.
There are other methods but you can add Application.Quit as the next line
and Excel should go away.