Find a file with wildcard character : FileSearch « File Path « VBA / Excel / Access / Word

Home
VBA / Excel / Access / Word
1.Access
2.Application
3.Data Type
4.Data Type Functions
5.Date Functions
6.Excel
7.File Path
8.Forms
9.Language Basics
10.Math Functions
11.Outlook
12.PowerPoint
13.String Functions
14.Windows API
15.Word
16.XML
Microsoft Office PowerPoint 2007 Tutorial
Microsoft Office Excel 2007 Tutorial
Microsoft Office Word 2007 Tutorial
VBA / Excel / Access / Word » File Path » FileSearch 
Find a file with wildcard character
 
Sub findFile()
Dim As Integer
   With Application.fileSearch
        .NewSearch
        .LookIn = "c:\"
        .FileName = "*.mdb"
        .SearchSubFolders = True
            If .Execute() > 0 Then
               For i = 1 To .FoundFiles.Count
                 Debug.Print .FoundFiles(i)
               Next i
            End If
    End With
End Sub

 
Related examples in the same category
1.The FileSearch Object
2.PropertyTests
3.The FoundFiles Collection Object
4.if a particular file exists, and False if not
5.searches the My Documents directory and its subdirectories for all XLS files that contain the text budget.
6.Find a file
7.File files with Application.FileSearch
8.Use Application.FileSearch to find files
java2s.com  |  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.