A
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
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