Torna al Thread

Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Me.Button4.Enabled = False Dim myOldProcess As Process Dim allOldProcess As Process() = Process.GetProcessesByName("EXCEL") 'ESEGUO EXCEL --------------------- Dim xlApp As New Excel.Application() Dim xlBooks As Excel.Workbooks = xlApp.Workbooks Dim xlBook As Excel.Workbook = xlBooks.Add Dim xlSheet As Excel.Worksheet = xlApp.ActiveSheet xlBook = xlApp.Workbooks.Open("D:\miofile.xls") xlSheet = xlBook.Worksheets(1) xlSheet.Activate() xlSheet.Range("A1").Value = "Hello Word" 'xlSheet.Range("INDIRIZZO").Value = "INDIRIZZO" xlBook.Save() 'xlBook.WebPagePreview() System.Threading.Thread.Sleep(3000) 'fine EXCEL --------------------- Dim value As Boolean = False Dim killProcess As Integer Dim myNewProcess As Process Dim allNewProcess() As Process = Process.GetProcessesByName("EXCEL") If allOldProcess.Length = 0 Then For Each myNewProcess In allNewProcess killProcess = myNewProcess.Id Next Else For Each myNewProcess In allNewProcess Dim idProcess As Integer = myNewProcess.Id For Each myOldProcess In allOldProcess If idProcess = myOldProcess.Id Then value = False Else value = True End If Next If value = True Then killProcess = (myNewProcess.Id) End If Next End If Dim exlProcess As Process = Process.GetProcessById(killProcess) exlProcess.Kill() Me.Button4.Enabled = True End Sub
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5