> I have created a dts package (to simplify) with 2 steps
>
> 1) open an excel file & run a macro
>
> 2) send an email that the job ran.
>
> step 2 is dependent on step 1. I have step 1 set up via a batch file
> which opens excel & the specific excel file (which contains a macro
> which runs automatically upon opening the excel file). Step 1 runs
> successfully but Excel doesn't shut down so step 1 never officially
> completes therefore step 2 does not run.
>
> Is there a way to systematically close excel so that step 2 will run?
>
> Thanks in advance for your help!
>