Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileSearch does not work, XP SVP1, Office 2002
I was testing the following filesearch in Excel by creating 3 text files in
the C:\ directory. I keep getting There were no files found. I tried this on another computer and it worked fine. I tried the code in access, same result. Sub filesearchtest() With Application.FileSearch .NewSearch .LookIn = "C:\" .SearchSubFolders = False .Filename = "*.txt" .MatchTextExactly = False '.FileType = msoFileTypeAllFiles 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 End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 to 2007 Macro containing "Filesearch" | Setting up and Configuration of Excel | |||
Trying to work with files copied from Office 2004 (MAC) in Office | Excel Worksheet Functions | |||
Unable to open Office 2007 files using Office 2002 XP | Excel Discussion (Misc queries) | |||
FileSearch inconsistencies between Office/Windows version combinat | Excel Programming | |||
Office automation application which will work with any version of office C#.NET | Excel Programming |