View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Closing die hard process EXCEL.EXE

Unless you have an unreleased reference to an object in the Excel
application. This can happen if you don't fully qualify all your
references.

--
Regards,
Tom Ogilvy


"Francesco Geri" wrote in message
...
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