| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting FileName from Search
I am using this search:
With Application.FileSearch .LookIn = DefaultFilePath .TextOrProperty = FleNme If .Execute(SortBy:=msoSortByFileName, _ SortOrder:=msoSortOrderAscending) 0 Then For i = 1 To .FoundFiles.Count MsgBox .FoundFiles(i) Next i Else MsgBox "There were no files found." End If End With How can I retrieve the file name? I've tried everything I know, which isn't much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a Variable Filename to a Constant Filename | Excel Programming | |||
| filename search and extract into a cell | Excel Discussion (Misc queries) | |||
| Help with filename search | Excel Programming | |||
| Search filename containing words | Excel Programming | |||
| Filename search using Office 97 with Windows 2000 | Excel Programming | |||
Threaded Mode
