LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
searching a text file and importing selected data brian Excel Discussion (Misc queries) 0 October 30th 07 08:44 PM
Searching, matching then searching another list based on the match A.S. Excel Discussion (Misc queries) 1 December 13th 06 05:08 AM
Searching the first name only Kelly Lim Excel Discussion (Misc queries) 7 June 17th 05 04:31 AM
VBA searching a row Fargo Holiday Excel Programming 5 December 24th 03 08:10 PM
Searching LC[_3_] Excel Programming 1 July 25th 03 12:29 AM


All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"