Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search For File Name

Status
Not open for further replies.
Savil

Savil

Programmer
Joined
Apr 28, 2003
Messages
333
Location
EU
Hi All
Can anyone think of a way of searching for a particular file name in all folders on a drive using vba

Thanks
 
Sort by date Sort by votes
You may use the Application.FileSearch object (deprecated in office2007).

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Sorry client still using Office 97 but I have just tripped over the lookin property which should do the trick
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

hermanlaksko
  • Locked
  • Question Question
Convert PDF file to text
Replies
6
Views
918
hermanlaksko
hermanlaksko
Moss100
  • Locked
  • Question Question
Open filtered for and set cursor at particular record
Replies
1
Views
831
Moss100
Moss100
Knicks
  • Question Question
Nested Column (Excel, CSV) : How to extract just the metadata or column names within a column of data
Replies
2
Views
146
Andrzejek
Andrzejek
renigar
  • Locked
  • Question Question
Code to write file path to field always writes to 1st record
Replies
5
Views
1K
dhookom
dhookom
ziffer68
  • Locked
  • Question Question
Pass Through query to create an alias for DB2 member
Replies
0
Views
3K
ziffer68
ziffer68

Part and Inventory Search

Sponsor

Back
Top