in meiner Variablen "Path" steht z.B. C:\Testdaten\
Wie ist es möglich, mir die Namen aller in diesem Verzeichnis enthaltenen Ordner, welche mit "A" beginnen in einer Listbox anzeigen zu lassen?
Viele Grüße und Danke,
Sebastian
Sub ordnerliste()
Dim oFS As Object, oFolder As Object, oFldr As Object
Set oFS = CreateObject("scripting.filesystemobject")
Set oFolder = oFS.getfolder("n:\test")
For Each oFldr In oFolder.subfolders
If Left(oFldr.Name, 1) = "A" Then
Sheets(1).ListBox1.AddItem oFldr.Name
End If
Next
End Sub
Sub Unterordner()
Dim Path As String
Dim fso As Object
Dim fo As Object
Dim sfo As Object
Path = "C:\Temp\"
Set fso = CreateObject("Scripting.FileSystemObject")
Set fo = fso.GetFolder(Path)
For Each sfo In fo.Subfolders
UserForm1.ListBox1.AddItem sfo.Name
Next 'sfo
UserForm1.Show
End Sub
Gruß IngolfPfad1 = "C:\Testdaten\"
Name1 = Dir(Pfad1, vbDirectory)
Do While Name1 <> ""
If Name1 <> "." And Name1 <> ".." Then
If (GetAttr(Pfad1 & Name1) And vbDirectory) = vbDirectory Then
If Left(Name1, 1) = "A" Then ListBox1.AddItem Name1
End If
End If
Name1 = Dir
Loop