1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
|
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Imports Microsoft.Office.Interop
Sub Transfert()
'Déclaration des variables
Dim appExcel As Excel.Application 'Application Excel
Dim wbExcel As Excel.Workbook 'Classeur Excel
Dim wsExcel As Excel.Worksheet 'Feuille Excel
appExcel = CreateObject("Excel.Application")
wbExcel = appExcel.Workbooks.Add
wsExcel = wbExcel.Worksheets(1)
'Placement des variables dans les cellules
'A modifier selon les besoins
wsExcel.Cells(1, 1).Value = TextBox1.Text
wsExcel.Cells(1, 2).Value = TextBox2.Text
'wsExcel.Cells(1, 3).Value = TextBox3.Text
'Rendre excle visible
appExcel.Visible = True
'Nettoyage mémoire
wsExcel = Nothing
wbExcel = Nothing
appExcel = Nothing
GC.Collect()
End Sub
Private Sub Label2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label2.Click
End Sub
End Class |
Partager