Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The following code gives a found files count of 3 where only 1 file
exists. set fs = Application.FileSearch With fs .NewSearch .FileName = "EXCEL.exe" .LookIn = "C:\Program Files" .SearchSubFolders = True .MatchTextExactly = True .FileType = msoFileTypeAllFiles End With fs.Execute For r = 1 To fs.FoundFiles.Count MsgBox fs.FoundFiles(r) Next r The MsgBox refers to the same file each time "C:\Program Files\Micrsoft Office\Office\EXCEL.exe" Any thoughts on how to refine the code to give the expected answer? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup returns unexpected result | Excel Worksheet Functions | |||
Unexpected Result | Excel Worksheet Functions | |||
Unexpected Result with "If" Logic/Conditional Statement | Excel Discussion (Misc queries) | |||
FV Function result is unexpected. | Excel Worksheet Functions | |||
Unexpected result | Excel Worksheet Functions |