FileSearch not working for C: ????

[Klopper]

Hi

Anyone have any idea why the code belwo works for all my network drives but not if I do a search in the C: hard drive?

With Application.FileSearch
.LookIn = "C:\TEMP"
.FileName = "*.mdb"
If .Execute() > 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
Else
MsgBox "There were no files found."
End If
End With

 

[Kryzsoccer]

If I understand your proble correctly, you want to find a file in a sub folder of your hard drive(C
The search you did does not check sub folders.
to make it check simply add the following right after .LookIn = "C:\"

.SearchSubFolders = True

Let me know if this helps!