application is not getting closed through automation

G

Guest

Hi

I am using VB.NET and Office 2003. I have written a small
program, which creats an excel application and writes teh
data into the sheet and the closes the application. But
when i go to the task manager, I can still see the
excel.exe running there.
Plese help me:)

The code I am using is :
Dim Excel As New Excel.ApplicationClass
' Get a new workbook
Dim oBook As Excel._Workbook = CType
(Excel.Workbooks.Add(oTemplate), Excel._Workbook)
....
...
oBook.SaveAs("c:\SearchResults.xls")
Excel.ActiveWorkbook.Close(False)

System.Runtime.InteropServices.Marshal.ReleaseComObject
(oBook) ' releases the workbook object
oBook = Nothing
Excel.Quit()

System.Runtime.InteropServices.Marshal.ReleaseComObject
(Excel) ' releases the excel object
Excel = Nothing


Thanks Vishal
 
B

BrianB

Try
Set Excel = Nothing

I wonder if you should be using something like 'MyExcel' instead, there
are often hidden problems with (semi-) reserved words.
 
G

Guest

I am doing that. Pls see the code attached with the
original post.
I am using VB.net so there is no set command. I am still
not able to close the excel.exe even after doing this.

Vishal
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top