Closing Excel File

[Ronin85]

Hi , I recently have much pain working with excel application especially closing excel . I try several method but with no success i try to urge garbage collector to dispose excel application object, I tried to kill excel process but i find it difficult to figure out which is the right process to kill .It is out of question to kill all process on the server so i have to find out which is the proper one bit I can't retrieve the id of the process after new excel application is created.I don't open excel in open window state otherwise it will be easy to retrieve the process id but ......

So I'll be very grateful to any help , because it makes me crazy already.

[jhardman]

what method are you using to create the file, and what methods have you tried to destroy it?

Jared

[Ronin85]

Actually I don't create file I have prepared pattern to write in it.The new process is created when i started new excel application.I already come with solution to kill process but I am not quite convinced that i have the right solution.

Dim i As Integer = 0

For i = 1 To xlWrkBook.Worksheets.Count
xlWrkSheet = xlWrkBook.Worksheets(i)
System.Runtime.InteropServices.Marshal.ReleaseComO bject(xlWrkSheet)
xlWrkSheet = Nothing
Next
For i = 1 To xlApp.Workbooks.Count
xlWrkBook = xlApp.Workbooks(i)
xlWrkBook.Close(False)
System.Runtime.InteropServices.Marshal.ReleaseComO bject(xlWrkBook)
xlWrkBook = Nothing
Next

xlApp.Quit()
System.Threading.Thread.Sleep(4000)
System.Runtime.InteropServices.Marshal.ReleaseComO bject(xlApp)
xlApp = Nothing
System.Threading.Thread.CurrentThread.CurrentCultu re = oldCI

GC.Collect()
GC.WaitForPendingFinalizers()
GC.Collect()
GC.WaitForPendingFinalizers()

this is the piece of code i tried to close excel , it have to work it is commonly use in my work but it doesn't work at me . I decided to write all process in hashtable and then start new excel application which generate EXCEL process
and after that i find the new process and take id of the process and when it is needed i kill it. Good but i am not quite sure how this will work on server.