MikeC14081972
Programmer
HI,
Been using an old version of Excel and use the following code to loop through the files in a folder and process them in the order they were last modified.
Now I have updated to Excel 2007 the line
throws an error as this has been removed from 2007
I know I could build code using FSO but want to be able to process any files in the order they were last modified still.
Can anyone help me out.
Thanks
Been using an old version of Excel and use the following code to loop through the files in a folder and process them in the order they were last modified.
Code:
Wtih Application.FileSearch
.NewSearch
.LookIn = "C:\Test\"
.FileType = msoFileTypeAllFiles
If .Execute(msoSortByLastModified, msoSortOrderAscending) >0 then
' Do Stuff
End If
End With
Now I have updated to Excel 2007 the line
Code:
With Application.FileSearch
I know I could build code using FSO but want to be able to process any files in the order they were last modified still.
Can anyone help me out.
Thanks