how to close an application using automation

G

Guest

Hi
I am writing an application using VB.NET and office 2003.
I write some data into the Excel sheetand tehn close it
but, I can still see teh excel.exe running in the task
manager. .Please 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 a lot..
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

Similar Threads

help !!! please... closing excel application using automation 3
application is not getting closed through automation 2
EXCEL.EXE process does not end after adding an excel chart 4
Chart Automation leaves hidden instance of Excel running 2
Import an Image into Excel using VB.Net and Option Strict On 1
Excel Automation Question 0
How to call excel function with a byref array parameter from VB.Ne 0
create MSProject programatically using asp.net web application (vb 0

Top