ACC97: Sample Procedure to Find the Location(s) of a File

MORE INFORMATION

1. Open the sample database Northwind.mdb.
2. Create a module and type the following line in the Declarations section if it is not already there:
   

         Option Explicit
   						

3. Type the following procedure:
   

         Function LocateFile(strFileName as String)
            Dim vItem As Variant
            With Application.FileSearch
               .FileName = strFileName
               .LookIn = "c:\"
               .SearchSubFolders = True
               .Execute
               For Each vItem In .FoundFiles
                  Debug.Print vItem
               Next vItem
            End With
         End Function
   						

4. To test this function, type the following line in the Debug window, and then press ENTER:
   

   ?LocateFile("northwind.mdb")

   
   Note that all locations of Northwind.mdb are printed in the Debug window.