Task Scheduler - Is One task triggers another possible

[Guest]

I have a task scheduled at 8:30pm. This task opens an excel spreadsheet
(which is set to run a macro when opened. This macro takes about 60 to 90
minutes to run) Upon completion of this task, I would like to copy a folder
from one directory to another (probably using a batch file). Is there any
way to schedule one task to run upon completion of another?

Thank you.
Regards,
Diane

 

[David Candy]

It possible but you might as well run the second program direct from the first task.

A batch file

Start "" /w excel workbook c:\myworkbook
Copy c:\*.* C:\somewhereelse

 

[Guest]

That's what I really wanted to do - but didn't know I could ;-( Great! Just
one more question. How do I CLOSE Excel after the first step. It won't go
to the copy step without my manually closing Excel.

Thanks David.
Regards,
Diane

 

[David Candy]

Can't you tell Excel to close itself. Normally the macro you are running in excel should close itself by
Application.Quit

 

[Guest]

Yup - I can - thanks for the help

Can't you tell Excel to close itself. Normally the macro you are running in excel should close itself by
Application.Quit