Thread
:
Scan a Directory
View Single Post
#
5
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 24
Scan a Directory
Try:
With Application.FileSearch
.LookIn = "C:\My Documents"
.Filename = "*"
If .Execute 0 Then
For x = 1 To .FoundFiles.Count
tFilename = .FoundFiles(x)
Lb_Dash.AddItem (tFilename)
Next x
Else
MsgBox "No Files"
End If
End With
HTH
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]