How to release Excel97 in VS.net 2003

[Arron]

After the following code is finished,I open the Task
manager,but the excel.exe is still running.
How can I release it from memory.
ps.I use vs.net 2003 + excel97
Thank you!!
Dim oExcel As Object
Dim oBook As Object
Dim oSheet As Object
oExcel = CreateObject("Excel.Application")
While myobj.read
oExcel.workbooks.open("C:\123.xls")
oSheet = oExcel.sheets("test")
oExcel.run("bb") 'Call marco
oExcel.save()
oExcel.quit()
GC.Collect()
oSheet = Nothing
oBook = Nothing
oExcel = Nothing
End While

 

[Bernie Yaeger]

Hi Arron,

After oexcel.quit, add this line:
marshal.releasecomobject(oexcel)

HTH,

Bernie Yaeger

 

[Arron]

What is marshal?
I add "marshal.releasecomobject(oexcel)"
but the VS.net said that "marshal is not declared"!!

========================================================

 

[Bernie Yaeger]

Hi Arron,

I'm pretty sure it's part of system.runtime.interopservices. Add this
imports statement:
Imports System.Runtime.InteropServices

Bernie

 

[Herfried K. Wagner [MVP]]

After the following code is finished,I open the Task
manager,but the excel.exe is still running.
How can I release it from memory.
ps.I use vs.net 2003 + excel97

PRB: Office Application Does Not Quit After Automation from Visual Studio .NET Client
<http://support.microsoft.com/?scid=kb;en-us;317109>