Phantom Excel.EXE Process

Hi,
I have an Excel file with user controls. The controls include a couple of drop-down boxes and a button.

The user makes some selections, then clicks the button. The VBA code in the Click event of the button creates a new Excel.Sheet object as follows:

Please Login or Register  to view this content.

This is late binding I guess.


It does some data populating using ADO & formatting with this newly created object and then saves it.

At the end of the code, I am closing this object and also setting all the objects to Nothing .

Once everything is done running, I close the generated excel file and also the main file (which I call the 'User Options' file). I close all instances of Excel. For some reason, there is an EXCEL.EXE process still running in Task Manager. My first guess was that there was memory leak in the code. I have checked the code thoroughly and have not found any leaks.


Here is the code, in general.

Please Login or Register  to view this content.

Can someone please help me figure out why it is leaving the Excel Process running, and what I can do about it?


Thanks.



Saad

Welcome to the Forum. Please read the Forum Rules & use Code tags when posting code.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread