Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default 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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Quit Method do not kill excel process Rui Oliveira Excel Programming 0 January 15th 04 04:51 PM
EXCEL.exe stays open after Quit method in an HTA myriams9 Excel Programming 5 December 4th 03 07:06 AM
How to Quit an Excel process? Joe Brown Excel Programming 0 October 1st 03 06:06 AM
to kill a excel process han keat Excel Programming 1 July 18th 03 07:32 AM
how to kill excel using a vbscript Harald Staff[_4_] Excel Programming 0 July 17th 03 10:02 PM


All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"