архивов *.zip и еще некоторых типов в чем загвоздка
Dim FoundFilesCount As Integer
Dim fs As FileSearch
Set fs = Application.FileSearch
fs.SearchSubFolders = True
With fs
.LookIn = "C:\"
.FileType = msoFileTypeAllFiles
.MatchTextExactly = False
.FileName = "*.*"
If .Execute() > 0 Then
FoundFilesCount = .FoundFiles.Count
For i = 1 To .FoundFiles.Count
MsgBox .FoundFiles(i))
Next i
Else
MsgBox "There were no files found."
End If
End With