Closing a Process.

Question

Hi all I start Excel as a process to import data from a worksheet this all works fine. I need to know how to end the process. I have tried setting the process variable to null but this does nothing the process still shows in Task Manager. Can anyone help me with this problem? Thanks in advance

jinwolf · Answer

Thanks simon it works perfect now.

shimtanny · Answer

Hi See: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatasqlclientsqlconnectionclassclosetopic.asp Here is a small example: // Create app. object open workbook and worksheet(s). Excel.Application excel = new Excel.ApplicationClass(); FileInfo file = new FileInfo(@..\..	est.xls); Excel.Workbook workbook = excel.Workbooks.Open(file.FullName Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing Type.Missing); Excel.Sheets worksheets = workbook.Sheets; Excel.Worksheet worksheet = (Excel.Worksheet) worksheets[Sheet1]; // Use worksheet... Excel.Range range = (Excel.Range) worksheet.Cells[11]; //Excel.Range range = worksheet.get_Range(A1 A4); object obj = range.Value2; // Cleanup... workbook.Close(false Type.Missing Type.Missing); excel.Quit(); Marshal.ReleaseComObject(range); Marshal.ReleaseComObject(worksheet); Marshal.ReleaseComObject(worksheets); Marshal.ReleaseComObject(workbook); Marshal.ReleaseComObject(excel); GC.Collect(); I hope i helped. Simon