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 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151
| Option Compare Database
Dim nb As Integer
Dim fact_tab(5, 9) As String
Function facture(datepiec As Date, numero As String, TIER As String, total_ttc As Single, somme_du As Single) As Single
Dim lg As Integer
For i = 0 To 9
fact_tab(0, i) = -1
Next
If nb < 0 Or nb > 9 Then
nb = 0
End If
If fact_tab(3, 0) <> TIER And fact_tab(2, 0) <> numero Then
nb = 0
End If
If nb = 0 Then
fact_tab(1, 0) = datepiec
fact_tab(2, 0) = numero
fact_tab(3, 0) = TIER
fact_tab(4, 0) = total_ttc
fact_tab(5, 0) = somme_du
nb = 1
Else
If nb = 1 Then
fact_tab(1, 1) = datepiec
fact_tab(2, 1) = numero
fact_tab(3, 1) = TIER
fact_tab(4, 1) = total_ttc
fact_tab(5, 1) = somme_du
nb = 2
Else
If nb = 2 Then
fact_tab(1, 2) = datepiec
fact_tab(2, 2) = numero
fact_tab(3, 2) = TIER
fact_tab(4, 2) = total_ttc
fact_tab(5, 2) = somme_du
nb = 3
Else
If nb = 3 Then
fact_tab(1, 3) = datepiec
fact_tab(2, 3) = numero
fact_tab(3, 3) = TIER
fact_tab(4, 3) = total_ttc
fact_tab(5, 3) = somme_du
nb = 4
Else
If nb = 4 Then
fact_tab(1, 4) = datepiec
fact_tab(2, 4) = numero
fact_tab(3, 4) = TIER
fact_tab(4, 4) = total_ttc
fact_tab(5, 4) = somme_du
nb = 5
Else
If nb = 5 Then
fact_tab(1, 5) = datepiec
fact_tab(2, 5) = numero
fact_tab(3, 5) = TIER
fact_tab(4, 5) = total_ttc
fact_tab(5, 5) = somme_du
nb = 6
Else
If nb = 6 Then
fact_tab(1, 6) = datepiec
fact_tab(2, 6) = numero
fact_tab(3, 6) = TIER
fact_tab(4, 6) = total_ttc
fact_tab(5, 6) = somme_du
nb = 7
Else
If nb = 7 Then
fact_tab(1, 7) = datepiec
fact_tab(2, 7) = numero
fact_tab(3, 7) = TIER
fact_tab(4, 7) = total_ttc
fact_tab(5, 7) = somme_du
nb = 8
Else
If nb = 8 Then
fact_tab(1, 8) = datepiec
fact_tab(2, 8) = numero
fact_tab(3, 8) = TIER
fact_tab(4, 8) = total_ttc
fact_tab(5, 8) = somme_du
nb = 9
Else
If nb = 9 Then
fact_tab(1, 9) = datepiec
fact_tab(2, 9) = numero
fact_tab(3, 9) = TIER
fact_tab(4, 9) = total_ttc
fact_tab(5, 9) = somme_du
nb = 10
End If
End If
End If
End If
End If
End If
End If
End If
End If
End If
lg = fact_tab(0, 0)
Set fs = CreateObject("Scripting.FileSystemObject")
'Création de l'objet fso
nom_fichier = "D:\Stage\test.doc"
Set a = fs.CreateTextFile(nom_fichier, True)
'Création d 'un fichier
a.writeline ""
'écriture dans le fichier
a.writeline ""
a.writeline "hello"
a.writeline ""
a.writeline ""
a.writeline "" & fact_tab(0, 0)
a.writeline "" & fact_tab(1, 0)
a.writeline "" & fact_tab(2, 0)
a.writeline "" & fact_tab(3, 0)
a.writeline "" & fact_tab(4, 0)
a.writeline "" & fact_tab(5, 0)
a.writeline ""
a.writeline ""
a.writeline "" & fact_tab(0, 1)
a.writeline "" & fact_tab(1, 1)
a.writeline "" & fact_tab(2, 1)
a.writeline "" & fact_tab(3, 1)
a.writeline "" & fact_tab(4, 1)
a.writeline "" & fact_tab(5, 1)
a.writeline ""
a.writeline ""
a.writeline ""
a.writeline ""
a.writeline ""
a.writeline ""
a.writeline ""
'completer la facture
a.Close
'fermeture fichier
End Function |
Partager