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
| Private Sub CommandButton202_Click() 'départ retour
ListFilesInFolder ("c:\...."), True
End Sub
Sub ListFilesInFolder(strFolderName As String, bIncludeSubfolders As Boolean)
' necessite d'activer la reference Microsoft Scripting RunTime
Static FSO As FileSystemObject
Dim oSourceFolder As Scripting.Folder
Dim oFile As Scripting.File
'Dim oSubFolder As Scripting.Folder'activer pour traiter les sous-repertoires
ActiveSheet.Cells.Clear
Set FSO = CreateObject("Scripting.FileSystemObject")
Set oSourceFolder = FSO.GetFolder(strFolderName)
For Each oFile In oSourceFolder.Files
r = [a65000].End(xlUp).Row
Cells(r, 1) = oFile.Name
Cells(r, 2) = oFile.Attributes
Cells(r, 3) = oFile.DateCreated
Cells(r, 4) = oFile.DateLastAccessed
Cells(r, 5) = oFile.DateLastModified
Cells(r, 6) = oFile.Drive
Cells(r, 7) = oFile.ParentFolder
Cells(r, 8) = oFile.ShortName
Cells(r, 9) = oFile.ShortPath
Cells(r, 10) = oFile.Size
Cells(r, 11) = oFile.Type
Next oFile
'If bIncludeSubfolders Then ' activer pour traiter les sous-repertoires
' For Each oSubFolder In oSourceFolder.SubFolders
' ListFilesInFolder oSubFolder.Path, True
' Next oSubFolder
'End If
End Sub |
Partager