M
Mark
Hi all,
as many had, i have some problems terminating the excel-process.
I implemented the solutions i found in this forums. Tried most
combinations of them ;-).
It still doesn't work.
I'll post my code-snippets below. I hope u can shine some light on the
solution.
Thx,
Mark
<code>
Dim excelApp As Excel.Application = New Excel.Application
Dim excelWorkbook As Excel.Workbook
Dim excelSheetInput As Excel.Worksheet
Dim excelSheetOutput As Excel.Worksheet
<doin sumthing>
Finally
excelSheetInput = Nothing
ReleaseCOMObject(excelSheetInput)
excelSheetOutput = Nothing
ReleaseCOMObject(excelSheetOutput)
'excelWorkbook.Close()
excelWorkbook = Nothing
ReleaseCOMObject(excelWorkbook)
excelApp.Quit()
excelApp = Nothing
ReleaseCOMObject(excelApp)
System.GC.Collect()
End Try
</code>
<code>
Try
System.Runtime.InteropServices.Marshal.ReleaseComObject(pobj)
Catch
Finally
pobj = Nothing
End Try
</code>
as many had, i have some problems terminating the excel-process.
I implemented the solutions i found in this forums. Tried most
combinations of them ;-).
It still doesn't work.
I'll post my code-snippets below. I hope u can shine some light on the
solution.
Thx,
Mark
<code>
Dim excelApp As Excel.Application = New Excel.Application
Dim excelWorkbook As Excel.Workbook
Dim excelSheetInput As Excel.Worksheet
Dim excelSheetOutput As Excel.Worksheet
<doin sumthing>
Finally
excelSheetInput = Nothing
ReleaseCOMObject(excelSheetInput)
excelSheetOutput = Nothing
ReleaseCOMObject(excelSheetOutput)
'excelWorkbook.Close()
excelWorkbook = Nothing
ReleaseCOMObject(excelWorkbook)
excelApp.Quit()
excelApp = Nothing
ReleaseCOMObject(excelApp)
System.GC.Collect()
End Try
</code>
<code>
Try
System.Runtime.InteropServices.Marshal.ReleaseComObject(pobj)
Catch
Finally
pobj = Nothing
End Try
</code>