[Excel 2002] Quit

[Bahy]

Hey, thanks to you, I finish my own codes. But there is still one more problem.

Set xlApp = nothing

This line of code did not work as expected. After run these codes, the process EXCEL was not killed and still using some resources. Have you all seen this? And how can this be done.? Do you think we need to call Kill process method?

[RobDog888]

I dont know what code you have but perhaps it would be best to start your own thread.

YOu cant kill the excel process just by setting hte applicaiton object variable to Nothing. You need to .Quit it first and before that any other object variables of Excel.

[Bahy]

Set excelWksht = Nothing
    excelWbk.Close Savechanges:=True
    Set excelWbk = Nothing
    excelApp.Quit
    Set excelApp = Nothing

I am sorry for being not so clear. My codes were above, it really did not work, and bythe way I am using Office XP.

[RobDog888]

But it just not that either. If you are implicitly creating excel objects you will have multiple references created and it will hang. Please post all your code.