View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Process will not end from task manager after vba code is over

Close the objects prior to setting them to nothing. Setting the objects to
nothing just detaches your app from the processes. It does not terminate the
process...
--
HTH...

Jim Thomlinson


" wrote:

There is one process (acsSRV.exe) in the Task Manager that does not
want to end even if set to nothing.
Any ideas???

Dim cvsApp As Object
Dim cvsConn As Object
Dim cvsSrv As Object
Dim Rep As Object


Dim Info As Object, Log As Object, b As Object


Set cvsApp = CreateObject("ACSUP.cvsApplication")
Set cvsConn = CreateObject("ACSCN.cvsConnection")
Set cvsSrv = CreateObject("ACSUPSRV.cvsServer")
Set Rep = CreateObject("ACSREP.cvsReport")


..
..
..
..
My code
..
..
..
..


Set b = Nothing
Set Log = Nothing
Set Info = Nothing
Set Rep = Nothing
Set cvsSrv = Nothing
Set cvsConn = Nothing
Set cvsApp = Nothing