i have an application which first checks if there is an excel file in certain
location, and then call DTS package to run. but my problem is everytime when
the application runs through, i have one excel file open and i couldn't
delete or remove...after running a few times, they take up all resource and
then got error: Subscribe out of range..

i tried to close workbooks, but only the application workbook found, other
files' workbooks can't be located! anybody has any clues? can i use process
to kill? but if so, no process such object in exce.