View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Kill Excel Process

Don't create another one, use the one that is there if there is one. If you
create anew, then kill it.

Something along the lines of

Dim xlApp As Object
Dim fCreated As Boolea n

On Error Resum Next
Set xlApp = GetObject(,"Excel.Application")
If xlApp Is Nothing Then
Set xlApp = CreatObject("Excel.Application")
If xlApp Is Nothin g Then
Exit Sub
Else
fCreated = True
End If
End If

'do your stuff

If fCreated Then
xlApp.Quit
End If

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Mike Moore" wrote in message
...
Could anyone provide ideas on how to kill an excel process? In our VB 6.0
app we populate data from MS Access to an MS Excel worksheet. If you look

in
task manager you could see the excel processes running in the background.
Also, how could we identify which excel process to kill? Especially in

the
case where a user is working on an ms excel worksheet and then generates

one
from our app. We don't want to kill the one the user is working on. Only
the one we create from the app.