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
| Private Sub Befehl31_Click()
On Error Resume Next
Dim appexcel As Excel.Application
Dim wbexcel As Excel.Workbook
Set appexcel = CreateObject("Excel.Application")
appexcel.Visible = True
Set wbexcel = appexcel.Workbooks.Open("C:\TEMP\est\Satre.xls")
appexcel.Sheets("Tabelle1").Select
appexcel.Cells(3, 1) = Me.Fa_Nr
appexcel.Cells(3, 2) = Me.Firmenname
appexcel.Cells(3, 3) = Me.Rue
appexcel.Cells(3, 4) = Me.PostLeitzahl
appexcel.Cells(3, 5) = Me.Lieu
appexcel.Cells(3, 6) = Me.Firma_Auswertung_sousformulaire.Form.ID
appexcel.Cells(3, 7) = Me.Firma_Auswertung_sousformulaire.Form.Kostenstelle
appexcel.Cells(3, 8) = Me.Firma_Auswertung_sousformulaire.Form.Art
appexcel.Cells(3, 9) = Me.Firma_Auswertung_sousformulaire.Form.Nettobetrag
'appexcel.Cells(5, 7) = rst![Nomduchamps]
appexcel.Cells(4, 6) = Me.Firma_Auswertung_sousformulaire.Form.ID
appexcel.Cells(4, 7) = Me.Firma_Auswertung_sousformulaire.Form.Kostenstelle
appexcel.Cells(4, 8) = Me.Firma_Auswertung_sousformulaire.Form.Art
appexcel.Cells(4, 9) = Me.Firma_Auswertung_sousformulaire.Form.Nettobetrag
appexcel.Cells(5, 6) = Me.Firma_Auswertung_sousformulaire.Form.ID
appexcel.Cells(5, 7) = Me.Firma_Auswertung_sousformulaire.Form.Kostenstelle
appexcel.Cells(5, 8) = Me.Firma_Auswertung_sousformulaire.Form.Art
appexcel.Cells(5, 9) = Me.Firma_Auswertung_sousformulaire.Form.Nettobetrag
Exit_Befehl31_Click:
Exit Sub
Err_Befehl31_Click:
MsgBox Err.Description
Resume Exit_Befehl31_Click
End Sub |
Partager