Ich möchte gerne wissen wieviel dateien in einem ordner sind?
Diesen Wert möchte ich dann gerne dazu benutzen, eine schleife so oft durchzulauen zu lassen wie dieser Wert ist.
Am besten mit einer For To-Schleife denke ich mir.
MFG Sven
Sub DateienZaehlenVariante2()
Dim sOrdner As String
Dim intz As Integer
sOrdner = "c:\Temp\*.*"
sOrdner = Dir(sOrdner)
sOrdner = "C:\TEMP"
Do While sOrdner <> ""
intz = intz + 1
sOrdner = Dir()
Loop
MsgBox "Im angegebenen Ordner befinden sich " & _
intz & " Dateien", vbInformation
End Sub
With Application.FileSearch
If .Execute() > 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
For i = 1 To .FoundFiles.Count
MsgBox .FoundFiles(i)
Next i
Else
MsgBox "There were no files found."
End If
End With
Set fs = Application.FileSearch
With fs
.LookIn = "C:\My Documents"
.FileName = "cmd*.*"
If .Execute > 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
For i = 1 To .FoundFiles.Count
MsgBox .FoundFiles(i)
Next i
Else
MsgBox "There were no files found."
End If
End With