FileTypes 集合

优质
小牛编辑
127浏览
2023-12-01

msoFileType 类型值的集合,决定 FileSearch 对象的 Execute 方法返回的文件类型。

使用 FileTypes 集合

使用 FileSearch 对象的 FileTypes 属性返回一个 FileTypes 集合。例如:

Set ft = Application.FileSearch.FileTypes

注释 FileSearch 对象的 FileType 属性清除 FileTypes 集合,并将集合中的第一项设置为 FileType 属性定义的文件类型。

所有搜索只有一个 FileTypes 集合,因此在执行搜索之前清除 FileTypes 集合很重要,除非希望搜索上次搜索的文件类型。清除集合的最简便方法是将 FileType 属性设置为要搜索的第一种文件类型。还可以使用 Remove 方法删除单个类型。要确定集合中每项的文件类型,请使用 Item 方法返回 msoFileType 值。

本示例搜索 C:\ 驱动器上的所有 HTML 和 Microsoft Excel 文件。

Sub SearchForFiles()

    'Declare a variable to act as a generic counter
    Dim lngCount As Long

    'Use a With...End With block to reference the
    'FileSearch object
    With Application.FileSearch

        'Clear all the parameters of the previous searches.
        'This method doesn't clear the LookIn property or
        'the SearchFolders collection.
        .NewSearch

        'Setting the FileType property clears the
        'FileTypes collection and sets the first
        'item in the collection to the file type
        'defined by the FileType property.
        .FileType = msoFileTypeWebPages

        'Add a second item to the FileTypes collection
        .FileTypes.Add msoFileTypeExcelWorkbooks

        'Display the number of FileTypes in the collection.
        MsgBox "You are about to search for " & .FileTypes.Count & _
            " file types."

        'Set up the search to look in all subfolders on the C:\ drive.
        .LookIn = "C:\"
        .SearchSubFolders = True

        'Execute the search and test to see if any files
        'were found.
        If .Execute <> 0 Then

            'Display the number of files found.
            MsgBox "Files found: " & .FoundFiles.Count

            'Loop through the list of found files and
            'display the path of each one in a message box.
            For lngCount = 1 To .FoundFiles.Count
                If MsgBox(.FoundFiles.Item(lngCount), vbOKCancel, _
                    "Found files") = vbCancel Then

                    'Break out of the loop
                    lngCount = .FoundFiles.Count

                End If
            Next lngCount
        Else
            MsgBox "No files found."
        End If
    End With
End Sub

本示例在 FileTypes 集合中循环,并删除所有非 Microsoft Word 或 Microsoft Excel 文件的文件类型(通常,清除 FileTypes 集合再从头开始更简便)。

Sub RemoveFileTypeFromCollection()

    'Define an integer to use as a counter
    'when iterating through the FileTypes collection.
    Dim intFileIndex As Integer

    'Use a With...End With block to reference the FileSearch object.
    With Application.FileSearch

        'Loop through all of the items in the FileTypes collection.
        intFileIndex = 1
        Do While intFileIndex <= .FileTypes.Count
            Select Case .FileTypes.Item(intFileIndex)
                Case msoFileTypeWordDocuments, msoFileTypeExcelWorkbooks
                Case Else

                    'If the file type isn't a Microsoft Word or
                    'Microsoft Excel file, remove it.
                    .FileTypes.Remove intFileIndex

                    'Decrement the counter so that no file types are missed.
                    intFileIndex = intFileIndex - 1
            End Select

            'Increment the counter to test the next file type.
            intFileIndex = intFileIndex + 1
        Loop

    End With
End Sub
FileSearch
FileTypes