PC Review


Reply
Thread Tools Rate Thread

what am I missing on filesearch

 
 
Jeff E
Guest
Posts: n/a
 
      30th Sep 2003
Hi - I am using the following code to find certain text
files in a specific path. I know that the file(s)
actually exist in the path I have specified, but
filesearch is not finding it. I have played around with
this and can get it to find .mdb files. This process is
being called from an access form.

With application.FileSearch
.NewSearch
.LookIn = "C:\Grant Files"
.FileType = msoFileTypeAllFiles
.SearchSubFolders = False (Have tried true)
.filename = "process*.*" (-- I have also done this
with *.* and can't get any hits either.)
.MatchTextExactly = False

If .Execute > 0 Then ' if1
totfiles = .FoundFiles.Count
More code follows this.
Else
Msgbox "No files found"
Endif
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
missing Application.FileSearch excel 2007 John Microsoft Excel Programming 3 14th May 2010 02:42 AM
FileSearch - help -Zoki- Microsoft Excel Programming 4 25th Apr 2006 06:12 PM
FileSearch Skimrhett Microsoft Excel Discussion 0 25th Oct 2004 06:38 PM
FileSearch Stephen Microsoft Excel Programming 8 12th Jun 2004 11:14 PM
Filesearch NIC Microsoft Access VBA Modules 4 20th Aug 2003 06:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:39 AM.