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
| Private Sub Class_Initialize()
Dim lerep, sListeFic, laligne As String
Dim i, nbFile As Integer
Dim Fic
Dim f1
Dim lgSession
Dim lgFtp As Long
Dim inRes
Dim sNomFic As String
Set rsFichiers = New ADODB.Recordset ' Définit la variable d'objet.
With rsFichiers
.Fields.Append "NumCompte", adBSTR, 11
.Fields.Append "Titulaire", adBSTR, 38
.Fields.Append "Bureau", adBSTR, 5
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Open
End With
End Sub
Public Property Get RecordCount() As Long
RecordCount = rsFichiers.RecordCount
End Sub
Public Sub Refresh()
Call Class_Initialize
End Sub
' alimente le tableau
Private Sub P_alimRow(rs As ADODB.Recordset, lNumCompte As String, lTitulaire As String, lBureau As String)
rs.AddNew
rs!NumCompte = lNumCompte
rs!Titulaire = lTitulaire
rs!Bureau = lBureau
rs.Update
End Sub
Public Sub P_alimRS(lefichier As String)
Dim LefichierSource
Dim laligne
Set fs = CreateObject("Scripting.FileSystemObject")
Set LefichierSource = fs.openTextFile(lefichier)
Do While Not LefichierSource.AtEndOfStream
laligne = LefichierSource.readline
Call P_alimRow(rsFichiers, Mid(laligne, 1, 11), Mid(laligne, 12, 38), Mid(laligne, 50, 5))
Loop
If rsFichiers.RecordCount > 0 Then
rsFichiers.MoveFirst ' Se place au début du jeu d'enregistrements.
End If
Set fs = Nothing
End Sub |
Partager