Windows taskmanager

[Bvisual]

Hello there

I am creating a excel file with vb.net but sometimes (not always !) the excel.exe process will stay open (sometimes even more then ones). Is there a code to remove all the excel.exe out off the taskmanager.


more ?

whats the code to merge cells in a excelfile using vb
whats the code to adjust kollomwith with vb


thx

 

[bigtimmin]

If you have application.Quit at the end of the routine, it should be closing it. However, you can use this code to close all running instances!

Dim myProcess() As Process
Dim instances As Process
myProcess = Process.GetProcessesByName("Excel")
For Each instances In myProcess
     instances.CloseMainWindow()
Next

Maybe this world is another planet’s Hell.

 

[ThatRickGuy]

Someone whould write a book entitled: "The Joys of Office Libraries." with a picture of someone beating their head against a wall on the cover.

Anyways. Make sure you close everything in excel in the correct order. And remember, Excel creates 3 worksheets by default as soon as you create a workbook.

So, make sure you close ALL of the worksheets, the workbook, then the app.

Then set the variables = to nothing.

Then call GC.Collect2()

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.