View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francesco Geri Francesco Geri is offline
external usenet poster
 
Posts: 8
Default Closing die hard process EXCEL.EXE

Hi,
I have a VB.NET program that opens an EXCEL workbook. In this program I modify the workbook, I save it, then I close it.
The code is like this:

Sub mySub()

Dim excelApp As Excel.Application
Dim excelDoc As Excel.Workbook

excelApp = New Excel.Application
excelDoc = excelApp.Workbooks.Open("c:\temp\test.xls")

'code that update the workbook....

excelDoc.Close(True)
excelDoc = Nothing

excelApp.Quit()
excelApp = Nothing

End Sub


I have no errors, but the EXCEL.EXE process keep alive after the execution.

The EXCEL.EXE process starts on statement:

excelApp = New Excel.Application

and it should die on statement:

excelApp.Quit()


It's right?

Thanks for help!

franx