Results 1 to 5 of 5

Thread: Find File API

  1. #1
    Leroy_Brown
    Guest

    Find File API

    Hi all.........I have a project in access 97 and have a function to see if as file exists in the stated path. If it does not.....i would like to call the windows file find window for the user to search with.....does anyone know where i could find something like that?

  2. #2
    Fanatic Member Patoooey's Avatar
    Join Date
    Aug 2001
    Location
    New Jersey, USA
    Posts
    774
    Returns the first file found that matches spec. If you know there will be dupes, search the VBForum for FindFirstFile or FSO to get a function that will return a list of all files matching spec.

    VB Code:
    1. Private Declare Function SearchTreeForFile Lib "IMAGEHLP.DLL" _
    2.     (ByVal lpRootPath As String, _
    3.     ByVal lpInputName As String, _
    4.     ByVal lpOutputName As String) As Long
    5.    
    6. Private Const MAX_PATH = 260
    7.  
    8. Private Sub Command1_Click()
    9. Dim s As String
    10. Dim sPath As String
    11. Dim lSlashPos As Long
    12.  
    13.     s = FindFile("c:\", "notepad.exe")
    14.    
    15.     lSlashPos = InStrRev(s, "\", -1, vbTextCompare)
    16.     sPath = Left(s, lSlashPos)
    17.     MsgBox "PATH  = " & sPath
    18. End Sub
    19.  
    20. Public Function FindFile(RootPath As String, _
    21.     FileName As String) As String
    22.    
    23.     Dim lNullPos As Long
    24.     Dim lResult As Long
    25.     Dim sBuffer As String
    26.    
    27.     On Error GoTo FileFind_Error
    28.    
    29.     'Allocate buffer
    30.     sBuffer = Space(MAX_PATH * 2)
    31.    
    32.     'Find the file
    33.     lResult = SearchTreeForFile(RootPath, FileName, sBuffer)
    34.    
    35.     'Trim null, if exists
    36.     If lResult Then
    37.         lNullPos = InStr(sBuffer, vbNullChar)
    38.         If Not lNullPos Then
    39.             sBuffer = Left(sBuffer, lNullPos - 1)
    40.         End If
    41.         'Return filename
    42.         FindFile = sBuffer
    43.     Else
    44.         'Nothing found
    45.         FindFile = vbNullString
    46.     End If
    47.    
    48.     Exit Function
    49.    
    50. FileFind_Error:
    51.     FindFile = vbNullString
    52.    
    53. End Function

  3. #3
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    instead of open Windows FInd File dialog, make your own with this. Just copy/paste, following the instructions
    VB Code:
    1. 'Create a form with a command button (command1), a list box (list1)
    2. 'and four text boxes (text1, text2, text3 and text4).
    3. 'Type in the first textbox a startingpath like c:\
    4. 'and in the second textbox you put a pattern like *.* or *.txt
    5.  
    6. Private Declare Function FindFirstFile Lib "kernel32" Alias "FindFirstFileA" (ByVal lpFileName As String, lpFindFileData As WIN32_FIND_DATA) As Long
    7. Private Declare Function FindNextFile Lib "kernel32" Alias "FindNextFileA" (ByVal hFindFile As Long, lpFindFileData As WIN32_FIND_DATA) As Long
    8. Private Declare Function GetFileAttributes Lib "kernel32" Alias "GetFileAttributesA" (ByVal lpFileName As String) As Long
    9. Private Declare Function FindClose Lib "kernel32" (ByVal hFindFile As Long) As Long
    10.  
    11. Const MAX_PATH = 260
    12. Const MAXDWORD = &HFFFF
    13. Const INVALID_HANDLE_VALUE = -1
    14. Const FILE_ATTRIBUTE_ARCHIVE = &H20
    15. Const FILE_ATTRIBUTE_DIRECTORY = &H10
    16. Const FILE_ATTRIBUTE_HIDDEN = &H2
    17. Const FILE_ATTRIBUTE_NORMAL = &H80
    18. Const FILE_ATTRIBUTE_READONLY = &H1
    19. Const FILE_ATTRIBUTE_SYSTEM = &H4
    20. Const FILE_ATTRIBUTE_TEMPORARY = &H100
    21.  
    22. Private Type FILETIME
    23.     dwLowDateTime As Long
    24.     dwHighDateTime As Long
    25. End Type
    26.  
    27. Private Type WIN32_FIND_DATA
    28.     dwFileAttributes As Long
    29.     ftCreationTime As FILETIME
    30.     ftLastAccessTime As FILETIME
    31.     ftLastWriteTime As FILETIME
    32.     nFileSizeHigh As Long
    33.     nFileSizeLow As Long
    34.     dwReserved0 As Long
    35.     dwReserved1 As Long
    36.     cFileName As String * MAX_PATH
    37.     cAlternate As String * 14
    38. End Type
    39. Function StripNulls(OriginalStr As String) As String
    40.     If (InStr(OriginalStr, Chr(0)) > 0) Then
    41.         OriginalStr = Left(OriginalStr, InStr(OriginalStr, Chr(0)) - 1)
    42.     End If
    43.     StripNulls = OriginalStr
    44. End Function
    45.  
    46. Function FindFilesAPI(path As String, SearchStr As String, FileCount As Integer, DirCount As Integer)
    47.     'KPD-Team 1999
    48.     'E-Mail: [email][email protected][/email]
    49.     'URL: [url]http://www.allapi.net/[/url]
    50.  
    51.     Dim FileName As String ' Walking filename variable...
    52.     Dim DirName As String ' SubDirectory Name
    53.     Dim dirNames() As String ' Buffer for directory name entries
    54.     Dim nDir As Integer ' Number of directories in this path
    55.     Dim i As Integer ' For-loop counter...
    56.     Dim hSearch As Long ' Search Handle
    57.     Dim WFD As WIN32_FIND_DATA
    58.     Dim Cont As Integer
    59.     If Right(path, 1) <> "\" Then path = path & "\"
    60.     ' Search for subdirectories.
    61.     nDir = 0
    62.     ReDim dirNames(nDir)
    63.     Cont = True
    64.     hSearch = FindFirstFile(path & "*", WFD)
    65.     If hSearch <> INVALID_HANDLE_VALUE Then
    66.         Do While Cont
    67.         DirName = StripNulls(WFD.cFileName)
    68.         ' Ignore the current and encompassing directories.
    69.         If (DirName <> ".") And (DirName <> "..") Then
    70.             ' Check for directory with bitwise comparison.
    71.             If GetFileAttributes(path & DirName) And FILE_ATTRIBUTE_DIRECTORY Then
    72.                 dirNames(nDir) = DirName
    73.                 DirCount = DirCount + 1
    74.                 nDir = nDir + 1
    75.                 ReDim Preserve dirNames(nDir)
    76.             End If
    77.         End If
    78.         Cont = FindNextFile(hSearch, WFD) 'Get next subdirectory.
    79.         Loop
    80.         Cont = FindClose(hSearch)
    81.     End If
    82.     ' Walk through this directory and sum file sizes.
    83.     hSearch = FindFirstFile(path & SearchStr, WFD)
    84.     Cont = True
    85.     If hSearch <> INVALID_HANDLE_VALUE Then
    86.         While Cont
    87.             FileName = StripNulls(WFD.cFileName)
    88.             If (FileName <> ".") And (FileName <> "..") Then
    89.                 FindFilesAPI = FindFilesAPI + (WFD.nFileSizeHigh * MAXDWORD) + WFD.nFileSizeLow
    90.                 FileCount = FileCount + 1
    91.                 List1.AddItem path & FileName
    92.             End If
    93.             Cont = FindNextFile(hSearch, WFD) ' Get next file
    94.         Wend
    95.         Cont = FindClose(hSearch)
    96.     End If
    97.     ' If there are sub-directories...
    98.     If nDir > 0 Then
    99.         ' Recursively walk into them...
    100.         For i = 0 To nDir - 1
    101.             FindFilesAPI = FindFilesAPI + FindFilesAPI(path & dirNames(i) & "\", SearchStr, FileCount, DirCount)
    102.         Next i
    103.     End If
    104. End Function
    105. Sub Command1_Click()
    106.     Dim SearchPath As String, FindStr As String
    107.     Dim FileSize As Long
    108.     Dim NumFiles As Integer, NumDirs As Integer
    109.     Screen.MousePointer = vbHourglass
    110.     List1.Clear
    111.     SearchPath = Text1.Text
    112.     FindStr = Text2.Text
    113.     FileSize = FindFilesAPI(SearchPath, FindStr, NumFiles, NumDirs)
    114.     Text3.Text = NumFiles & " Files found in " & NumDirs + 1 & " Directories"
    115.     Text4.Text = "Size of files found under " & SearchPath & " = " & Format(FileSize, "#,###,###,##0") & " Bytes"
    116.     Screen.MousePointer = vbDefault
    117. End Sub

  4. #4
    PowerPoster
    Join Date
    Jul 1999
    Posts
    5,923
    If you really do want the Windows dialog, see this http://www.mvps.org/vbnet/index.html...ndallfiles.htm

  5. #5
    Leroy_Brown
    Guest
    I had actually allready found that one but I am on a network with oodles of drives so it could be anywhere. That one needs the drive specified. The only way i could think about getting around it would be an input box but that is a tad ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width