Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Searching
hello,
im having trouble with this part of my program in that it doesnt distinguish between FILES and FOLDERS. if there is an excel FILE in this section of the folder with the same name as the user has entered, it says it found one. i only want it to return a positive value if it found a FOLDER with the name entered by the user. With Application.FileSearch .LookIn = "\\Cpi-server-1 \estimate\Quotes\EST" & Range("q262") & "000\EST" & Range ("q263") & "00" .Filename = Range("q261") If .Execute 0 Then MsgBox "File '" & Range("q261") & "' already exists with " & .FoundFiles.Count & " file(s) in it." Else |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
searching a text file and importing selected data | Excel Discussion (Misc queries) | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
Searching the first name only | Excel Discussion (Misc queries) | |||
VBA searching a row | Excel Programming | |||
Searching | Excel Programming |