Quit Method do not kill excel process

  • Thread starter Thread starter Rui Oliveira
  • Start date Start date
R

Rui Oliveira

Hi,

I am using the Quit method to close the Excel
excelApp.Quit
Set excelApp = Nothing

The Excel is closed but the excel process still running.
What can I do to stop this process?

BTW: I tested with "Word" too, and with "word" works. The
Quit method close the word application and stop the word
process

Thanks,
Rui Oliveira
 
You have probably created a non releasable reference to excel.

this can happen if you do something like

ActiveCell.Value = 3

You should fully qualify all references

excelApp.ActiveCell.Value = 3

sometimes it can be hard to find these unqualified references, such as when
the argument to a method uses a reference

excelApp.Activesheet.Range("A1:B30").Sort Key1:=Range("A1")

the Key:=Range("A1") is not fully qualified and would create a
non-releasable reference as an example.
 
Thanks.
Rui
-----Original Message-----
You have probably created a non releasable reference to excel.

this can happen if you do something like

ActiveCell.Value = 3

You should fully qualify all references

excelApp.ActiveCell.Value = 3

sometimes it can be hard to find these unqualified references, such as when
the argument to a method uses a reference

excelApp.Activesheet.Range("A1:B30").Sort Key1:=Range ("A1")

the Key:=Range("A1") is not fully qualified and would create a
non-releasable reference as an example.

--
Regards,
Tom Ogilvy





.
Click to expand...
 
Back
Top