Hi All,
I am getting a memory leak when I try to shut down an instance of Excel controlled by an MTS DLL. The code I am using seems to be pretty standard (VB 6). However when I close the Excel instance and set it equal to nothing the MTS engine does not release the memory. This may be due to the MTS settings but they are set to hold completed threads for 3 min - the Excel memory seems to be held by MTS indefinitely. This can be seen by monitoring the mtx.exe process in task manager. Every time a new Excel instance is loaded the memory usage goes up for this process, however when Excel is shutdown the memory usage does not decrease. This causes the eventual shutdown of the server.
Anyone have a similiar problem and if so how did you manage it ?

Many thanks
Len