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
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.