Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am using the following code to find a file on the C drive. The file is there, but the code keeps saying no file was found. Any help? Thanks. Sub test() Set fs = Application.FileSearch With fs .LookIn = "C" .Filename = "Fname.xls" If .Execute(SortBy:=msoSortByFileName, _ SortOrder:=msoSortOrderAscending) 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 | |
|
|
![]() |
||||
Thread | Forum | |||
find dependent files | Excel Discussion (Misc queries) | |||
Where is "open/tools/find/find files that match these criteria"? | Excel Discussion (Misc queries) | |||
Excel can't find files | Excel Discussion (Misc queries) | |||
FileSearch doesn't find zip files | Excel Programming | |||
Import multiple files macro can't find files | Excel Programming |