Excel does not exit with scheduled DTS package

I have an Excel project that runs macros against a SQL db database and updates some spreadsheets. The database is updated nightly using DTS and then we are manually running the macros in the morning. Well I tried adding the macros to the DTS package to run them after the database had been updated but unless I set the security to allow all macros to be run without confirmation, I was not able to get them to run from the package.

Since I did not want to disable macro security on this machine, I decide to pull the code from the macro and place the code in an ActiveX script. I’m now automating Excel through this script to do what I need. This works well if I execute the package from within SQL Server Enterprise Manager.

If I schedule the package to run, it updates the spreadsheets like it should but it does not kill the Excel process at the end of the package like it should. This does not make the package fail, it just never exits until you go to task manager and end the process there.

Why would the work if you manually start the package but not if you schedule the package?