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
| Public Sub cmdFolder_Click()
On Error GoTo 0
Dim fso As FileSystemObject, dossier As Folder, sousdossier As Folder, Fichier As File
Set fso = New FileSystemObject
Set dossier = fso.GetFolder("c:\Fichiers_cheminots")
LD = Len(dossier)
AD = -1 'ligne dos
BD = 0 'colonne dos
AF = -1 'ligne fich
BF = 0 'colonne fich
C = 0
scan dossier
End Sub
Public Sub scan(ByVal dossier As Folder) '
BF = 0 'colonne fich
For Each Fichier In dossier.Files
BF = BF + 1
LF = Len(Fichier) - LD - LS 'Len(Sdos)
' y = "fich " & str(AD) & "," & str(BF) & " " & Right(Fichier, LF)
'Debug.Print y
Call ModTable("", str(AD), str(BF), Right(Fichier, LF))
Next
For Each sousdossier In dossier.SubFolders
AD = AD + 1
BD = BD + 1
LS = Len(sousdossier) - LD
'x = "Sdos " & str(AD) & "," & str(BD) & " " & Right(sousdossier, LS)
'Debug.Print x
Call ModTable(str(AD), "", sousdosier, Right(Fichier, LF), Right(sousdossier, LS))
scan sousdossier
Next
End Sub
Public Sub ModTable(NN As Integer, abrev As String, sD As String, S1 As String, S2 As String)
On Error GoTo 0
Set rs = CurrentDb.OpenRecordset("ABC", dbOpenDynaset)
With rs
.AddNew
!Nr = NN
!ABR = abrev
!sDos = sD
!BaseO = S1
!baseD = S2
.Update
End With
End Sub |
Partager