Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
L.S.
I created the Macro you find here below. Zip-files that reside in the directory are not listed. Replacing Filename "*.zip" by "*.*" lists every file except the zip- files. I've reviewed contents in the collections PropertyTests and Filetypes too, but without results. Execution of the FileSearch interactively at the Excel- sheet using the menu-option, has the same result. It also doesn't list zip-files. Kind regards, Hub van de Laar Private Sub ListZipFiles() Dim FS As FileSearch, I As Integer With Application.FileSearch .NewSearch .LookIn = "D:\" .FileType = msoFileTypeAllFiles .Filename = "*.zip" .SearchSubFolders = False If .Execute 0 Then For I = 1 To .FoundFiles.Count Debug.Print .FoundFiles(I) Next I Else MsgBox "There were no files found." End If End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.FileSearch | Excel Discussion (Misc queries) | |||
FileSearch in a combo box | Excel Discussion (Misc queries) | |||
Import multiple files macro can't find files | Excel Programming | |||
FileSearch Code | Excel Programming | |||
FileSearch Problem | Excel Programming |