Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hallo newsgroup,
i have a problem with the application.filesearch.foundfiles command. sometimes i get a wrong result. instead of two files (which are in the directory) i get zero or one as result. if i use instead of .Filename = "*.xls" .Filename = "*.*" it takes a lot of time (nearly 30 seconds before the ".execute" command comes to an end), but the result is ok. if i run the orign code afterwards the result for .Filename = "*.xls" is correct too. Here is the code that provokes wrong results: With fs .NewSearch .LookIn = xlsPath .SearchSubFolders = False .Filename = "*.xls" .MatchTextExactly = True .FileType = msoFileTypeAllFiles If .Execute() 0 Then For j = 1 To .FoundFiles.Count ... Any idea Thanks in advance Lars |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
FoundFiles | Excel Programming | |||
removing the file extension while listing files via foundfiles | Excel Programming | |||
Using FoundFiles to list by path and filename | Excel Programming | |||
Using .FoundFiles to list files by path and file name | Excel Programming | |||
.Foundfiles Question | Excel Programming |