how to stop a hidden session from Excel
 

I asked this in the Access forum but no solution.
I am opening Excel from Access. Problem is many times a hidden session
remains in the windows task manager - processes.
I checked my code (all explicit declaration), send it to the Access forum,
changed it as they suggested but nothing helps.
I tried different API calls from the web but they do not stop Excel.
How can I close this hidden session from Excel?

how to stop a hidden session from Excel
 

If, say, xl is your instance of Excel, you need to

xl.Quit

If you have open and unsaved workbooks, save the workbook first or if you do
not want to save it, set

xl.Axtiveworkbook.Saved = True

how to stop a hidden session from Excel
 

did you release all references to excel
did you use
Application.Quit

If you did the Application.Quit and still have the problem, then it is a
good bet you didn't release all references even if you think you have.

Break you code down to the minimal number of commands to open and close
Excel. Get that working, then start adding things back until you encounter
the problem. That will give an indication of where you have the problem.

--
Regards,
Tom Ogilvy


"Michel Peeters" wrote:

I asked this in the Access forum but no solution.
I am opening Excel from Access. Problem is many times a hidden session
remains in the windows task manager - processes.
I checked my code (all explicit declaration), send it to the Access forum,
changed it as they suggested but nothing helps.
I tried different API calls from the web but they do not stop Excel.
How can I close this hidden session from Excel?

how to stop a hidden session from Excel
 

tks, but I tried did this already many times.
Is not there another way to kill excel ?
Michel
"Tom Ogilvy" wrote in message
...
did you release all references to excel
did you use
Application.Quit

If you did the Application.Quit and still have the problem, then it is a
good bet you didn't release all references even if you think you have.

Break you code down to the minimal number of commands to open and close
Excel. Get that working, then start adding things back until you
encounter
the problem. That will give an indication of where you have the problem.

--
Regards,
Tom Ogilvy


"Michel Peeters" wrote:

I asked this in the Access forum but no solution.
I am opening Excel from Access. Problem is many times a hidden session
remains in the windows task manager - processes.
I checked my code (all explicit declaration), send it to the Access
forum,
changed it as they suggested but nothing helps.
I tried different API calls from the web but they do not stop Excel.
How can I close this hidden session from Excel?

how to stop a hidden session from Excel
 

Trying and doing are two separate things. Maybe you don't have an unreleased
reference, but it is highly likely you do.

Are there ways to kill a process - sure, using the windows API.

http://www.experts-exchange.com/Prog..._20792368.html

--
Regards,
Tom Ogilvy


"Michel Peeters" wrote:

tks, but I tried did this already many times.
Is not there another way to kill excel ?
Michel
"Tom Ogilvy" wrote in message
...
did you release all references to excel
did you use
Application.Quit

If you did the Application.Quit and still have the problem, then it is a
good bet you didn't release all references even if you think you have.

Break you code down to the minimal number of commands to open and close
Excel. Get that working, then start adding things back until you
encounter
the problem. That will give an indication of where you have the problem.

--
Regards,
Tom Ogilvy


"Michel Peeters" wrote:

I asked this in the Access forum but no solution.
I am opening Excel from Access. Problem is many times a hidden session
remains in the windows task manager - processes.
I checked my code (all explicit declaration), send it to the Access
forum,
changed it as they suggested but nothing helps.
I tried different API calls from the web but they do not stop Excel.
How can I close this hidden session from Excel?

how to stop a hidden session from Excel
 

Michel,
You may have tried but you have not succeeded.
The fact that Excel is not being released indicates there is a reference
preventing it from doing so.
To kill the process everytime is like ramming your car into a wall whenever
you want to stop because you cannot be bothered to fix the car's breaks.

NickHK

"Michel Peeters" wrote in message
...
tks, but I tried did this already many times.
Is not there another way to kill excel ?
Michel
"Tom Ogilvy" wrote in message
...
did you release all references to excel
did you use
Application.Quit

If you did the Application.Quit and still have the problem, then it is a
good bet you didn't release all references even if you think you have.

Break you code down to the minimal number of commands to open and close
Excel. Get that working, then start adding things back until you
encounter
the problem. That will give an indication of where you have the
problem.

--
Regards,
Tom Ogilvy


"Michel Peeters" wrote:

I asked this in the Access forum but no solution.
I am opening Excel from Access. Problem is many times a hidden session
remains in the windows task manager - processes.
I checked my code (all explicit declaration), send it to the Access
forum,
changed it as they suggested but nothing helps.
I tried different API calls from the web but they do not stop Excel.
How can I close this hidden session from Excel?