Torna al Thread

Dim Ragio As String = Assemblatore.Anagrafica.TxtRagione.Text Dim Ind As String = Assemblatore.Anagrafica.TxtInd.Text Dim Loc As String = Assemblatore.Anagrafica.TxtLoc.Text Dim Cap As String = Assemblatore.Anagrafica.TxtCap.Text Dim Prov As String = Assemblatore.Anagrafica.TxtProv.Text Dim Iso As String = Assemblatore.Anagrafica.TxtIso.Text Dim Piva As String = Assemblatore.Anagrafica.TxtPiva.Text Dim CodF As String = Assemblatore.Anagrafica.TxtCf.Text Dim Tel As String = Assemblatore.Anagrafica.TxtTel.Text Dim Mail As String = Assemblatore.Anagrafica.TxtMail.Text Dim xlApp As Microsoft.Office.Interop.Excel.Application ' Riferimento all'applicazione Excel Dim xlBook As Microsoft.Office.Interop.Excel.Workbook ' Riferimento al Workbook Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet ' Riferimento al Worksheet xlApp = New Microsoft.Office.Interop.Excel.ApplicationClass xlBook = xlApp.Workbooks.Open(Me.ExcelFilePath) xlSheet = xlBook.Worksheets("PREVENTIVO") xlSheet.Activate() xlSheet.Cells(4, 44) = Ragio xlSheet.Cells(5, 44) = Ind xlSheet.Cells(6, 44) = Cap xlSheet.Cells(6, 51) = Loc xlSheet.Cells(6, 81) = Prov Dim prev As String xlSheet.PrintOutEx(, , , True) prev = "C:\Prev.xls" xlBook.SaveAs(prev, , , , , , , , , , , ) xlApp.Quit() xlBook.Save() xlSheet = Nothing xlBook = Nothing xlApp = Nothing MessageBox.Show("Il file è stato salvato in C:\") Dim processo As New Process processo.StartInfo.FileName = "C:\Prev.xls" processo.StartInfo.Verb = "Print" processo.Start()
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5