Quit Method do not kill excel process
 

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

Quit Method do not kill excel process
 

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


"Rui Oliveira" wrote in message
...
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

Quit Method do not kill excel process
 

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


"Rui Oliveira"
wrote in message
...
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



.