Torna al Thread

Public Sub verifica() Dim appExcel As New Microsoft.Office.Interop.Excel.Application appExcel.Visible = False Dim file As String 'l'idea è di poterli modificare a piacimento Dim foglio As String file = "file.xls" foglio = "nome_del_foglio" Dim WB As Microsoft.Office.Interop.Excel.Workbook = appExcel.Workbooks.Open(file) Dim WS As Microsoft.Office.Interop.Excel.Worksheet = WB.Worksheets(foglio) Dim scadenze As New List(Of scadenza) For i As Integer = 2 To 38 Dim s As New scadenza s.indirizzo = WS.Range("B" & i).Text s.data = WS.Range("A" & i).Text scadenze.Add(s) Next For Each s As scadenza In scadenze '30 giorni prima If DateDiff(DateInterval.Day, Now, s.data) <= 30 Then MsgBox("tra " & DateDiff(DateInterval.Day, Now, s.data) & " giorni scade " & s.indirizzo) End If Next WB.Close(SaveChanges:=False) appExcel.Quit() appExcel = Nothing 'killo il processo excel Dim processi() As Process = Process.GetProcessesByName("EXCEL") For Each processo As Process In processi If processo.MainWindowTitle = "" Then processo.Kill() End If Next End Sub
Copyright © dotNetHell.it 2002-2025
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5