Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have *.cab file c:\temp. But why I couldn't search *.cab with below code ?It shown me all files but excluded *.cab? Please help, thanks. With Application.FileSearch .LookIn = "C:\temp" .Filename = "*.*" .SearchSubFolders = True If .Execute(SortBy:=msoSortByFileName, _ SortOrder:=msoSortOrderAscending) 0 Then MsgBox "Number of *.txt was found: " & .FoundFiles.Count Debug.Print "---Number of file found : " & .FoundFiles.Count For i = 1 To .FoundFiles.Count Debug.Print .FoundFiles(i) Next i Else 'exit program if no file was found MsgBox "There were no files was found! Please check" End End If End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File:1 and File:2 -- Double Files when Opening One File | Excel Discussion (Misc queries) | |||
I saved file A over file B. Can I get file B back? | Excel Discussion (Misc queries) | |||
opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
I SAVED A FILE OVER ANOTHER A FILE IN EXCEL. THE OLD FILE WAS AN . | Excel Discussion (Misc queries) | |||
i received a file that reads powerpoint document file file exten. | Excel Discussion (Misc queries) |