ASP Excel.application processus not killed

[delorfra]

Hi,

despite closing the workbook I opened, quitting the Excel.application object and using set .. = Nothing, the Excel processus is not killed. So each time the code is called, a new instance of Excel is created and stack abobe the previous ones.

Any idea ?

Set objXL = createObject("Excel.Application&quot
...
objXL.Worksheets("Fr1&quot.Activate
set oSheet = objXL.activeworkbook.activesheet
....
objXL.Worksheets("Fr2&quot.Activate
set oSheet2 = objXL.activeworkbook.activesheet
....
set oSheet = Nothing
set oSheet2 = Nothing
objXL.activeworkbook.close
objXL.quit
set objXl = Nothing


Thanks

 

[tsuji]

Hello, delorfra.

Since the script is very much fragmentary, cannot figure out exactly what was going on there. Although I have some serious reserve of quite a few of your constructions, such as objXL.Worksheets("xxx&quot there, but, if I concentrate on the sole phenonmenon you raised, I would suspect that the workbook is not closed out correctly at all.

Hence to test out the theory, suppress the DisplayAlerts before the activeworkbook.close, namely,

...
objXL.DisplayAlerts=False 'adding this line
objXL.activeworkbook.close
objXL.quit

See if you can kill off the process.

If you can, it proves the theory.

regards - tsuji

 

[ToddWW]

No experience in Automating Excel here, but see if anything in the Microsoft Example helps.

http://support.microsoft.com/support/kb/articles/Q198/7/03.ASP

ToddWW