Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Slow FileSearch Routine
The code below slows down for several seconds because of
the "LastModified" line, and I can't figure out why, since there are only a few dozen files involved here. If I take out that one line, the code executes instantly. Any ideas? Directory = Range("Inputsubdirectory").Value On Error Resume Next With Application.FileSearch .NewSearch .LookIn = Directory .Filename = "*.xls*" .LastModified = msoLastModifiedLastMonth .SearchSubFolders = False .Execute End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Application.FileSearch | Excel Programming | |||
Problem with Filesearch | Excel Programming | |||
FileSearch using VBA | Excel Programming | |||
.FileSearch | Excel Programming | |||
FileSearch Code | Excel Programming |