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.