1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
While Not Rst_cot.EOF
appexcel.Cells(i, 1) = Rst_cot![Num_Ent1]
appexcel.Cells(i, 2) = Rst_cot![RaisonSociale_Ent]
appexcel.Cells(i, 3) = Rst_cot![TypeAdherent_Ent]
appexcel.Cells(i, 4) = Rst_cot![Num_Cotisations]
appexcel.Cells(i, 5) = Rst_cot![Annee_Cotisation]
appexcel.Cells(i, 6) = Rst_cot![MontantAnnee_Cotisations]
appexcel.Cells(i, 7) = Format(Rst_cot![DateAnee_Cotisations], "dd/mm/yyyy")
appexcel.Cells(i, 8) = Format(Rst_cot![DateEnvoi_Annee], "dd/mm/yyyy")
appexcel.Cells(i, 9) = Format(Rst_cot![Rappel1_Annee], "dd/mm/yyyy")
appexcel.Cells(i, 10) = Format(Rst_cot![Rappel2_Annee], "dd/mm/yyyy")
'Passer au suivant
Rst_cot.MoveNext |
Partager