cominterop excel and c#

[Ariel Gimenez]

Hi
in my app im working with excel using cominterop when fished my work with
excel i execute this code

oWB.Close(null, null,null);
oXL.Workbooks.C lose();
oXL.Quit();
System.Runtime. InteropServices .Marshal.Releas eComObject (oXL);
System.Runtime. InteropServices .Marshal.Releas eComObject (oSheet);
System.Runtime. InteropServices .Marshal.Releas eComObject (oWB);
oSheet=null;
oWB=null;
oXL = null;
GC.Collect();
but Excel.exe still remains in memory untill i unload my exe, any ideas?

Thanks

[Mattias Sjögren]

Ariel,

but Excel.exe still remains in memory untill i unload my exe, any ideas?

There are still intermediate objects (such as the Workbooks
collection) that haven't been released, and they might keep Excel
running.

Mattias

--
Mattias Sjögren [MVP] mattias @ mvps.org
http://www.msjogren.net/dotnet/ | http://www.dotnetinterop.com
Please reply only to the newsgroup.

[Bob Grommes]

But Mattias,

In his code he's closed the workbooks, shut down Excel, released the
associated COM objects, and set them to null. So in what sense are there
any intermediate objects that haven't been released??

And in any event -- what would the solution be?

--Bob

"Mattias Sjögren" <ma************ ********@mvps.o rg> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

Ariel,

but Excel.exe still remains in memory untill i unload my exe, any ideas?

There are still intermediate objects (such as the Workbooks
collection) that haven't been released, and they might keep Excel
running.

Mattias

[Ariel Gimenez]

Thanks Mattias and Bob, i dont know whats happen, but affortunately, build
release mode and running the executable closes the excel completely, the
problem was when running in debug mode from the vs.net 2003 ide

"Bob Grommes" <bo*@bobgrommes .com> wrote in message
news:eG******** ******@TK2MSFTN GP09.phx.gbl...

But Mattias,

In his code he's closed the workbooks, shut down Excel, released the
associated COM objects, and set them to null. So in what sense are there
any intermediate objects that haven't been released??

And in any event -- what would the solution be?

--Bob

"Mattias Sjögren" <ma************ ********@mvps.o rg> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. ..

Ariel,

but Excel.exe still remains in memory untill i unload my exe, any

ideas?
There are still intermediate objects (such as the Workbooks
collection) that haven't been released, and they might keep Excel
running.

Mattias

[Mattias Sjögren]

Bob,

In his code he's closed the workbooks,
Right, but not the workbook collection object returned here

oXL.Workbooks.C lose();
^^^^^^^^^

To release that object you'd have to do

Excel.Workbooks wbs = oXL.Workbooks;
wbs.Close();
Marshal.Release ComObject(wbs);

And in any event -- what would the solution be?

Be really careful to release everything object you touch (which can
make the code really ugly) or force a garbage collection after you're
done with all the objects. Neither way is really good.

Mattias

--
Mattias Sjögren [MVP] mattias @ mvps.org
http://www.msjogren.net/dotnet/ | http://www.dotnetinterop.com
Please reply only to the newsgroup.