Excel 2000 Runtime Does Not Unload
I'm hoping someone can help here. I've been working on a project that requires data exports to Excel spreadsheets. I've done this successfully in InterDev w/a COM component built in VB6, and have migrated both the webpage and COM into VS.Net. The problem is that when the code is finished, Excel.EXE is still running - despite calling the Quit() method.
I am using Excel 2000 right now and have not updated to Office 2003 as of yet. This simple code example causes this:
Private Sub RunExcelCheck()
Dim objExcel As New Excel.Application()
System.Threading.Thread.Sleep(10000) 'So I can see the .exe file running
objExcel = Nothing
Help! This is the last piece to a successful migration!