Reposting Excel/Access question

[ChrisBat]

Reposted from feb 16th. Anybody able to help?
Thanks,
Chris

That's actually the code that i got last week - I may not
be setting it properly, because it will close excel, but
the excel.exe process will still show up on the Task
Manager > Processes tab....any other suggestions?

-----Original Message-----
I got this from Brian Reich. It may help you. Good luck.

Here's a little code snippet I tested with:

Dim o As Object
Set o = CreateObject("Excel.Application")
MsgBox o
MsgBox "Test Me"
o.Quit
Set o = Nothing

when the "test me" msgbox is open, you can launch task
manager and see Excel.exe running. Then, once you hit ok
and the code completes, you will see in task manager that
the excel instance has dissapeared.
What you were probably doing before was launching a new
Excel process (this won't show up in the Applications
section of the task manager because you launched it through
another process without a main window, but it does show
up in the processes section as you discovered), and then
closing Access without quiting the excel process. Since the
Excel.exe instance is its own process and not a child
object of the Access process, it remained alive even after
you closed Access.
--
Bryan Reich

Jim
.

..