B
Ben
Greetings!
I am trying to use the FileSearch object to search through
folders for any file grater than the date 01/01/2004.
However, the closest thing to specifying a date is the
property .LastModified, which only accepts a handfull of
constants. Is there any way to use an actual date for this?
Sample code:
With Application.FileSearch
.NewSearch
.LookIn = "C:\"
.FileType = 1
.TextOrProperty = "*Test*"
.LastModified = msoLastModifiedYesterday
.Execute
If .Execute() > 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
Else
MsgBox "There were no files found."
End If
End With
I want to change the .LastModified property to look
something like this:
.LastModified > "#01/01/2004#"
Is there another way?
Thanks,
The Ben
I am trying to use the FileSearch object to search through
folders for any file grater than the date 01/01/2004.
However, the closest thing to specifying a date is the
property .LastModified, which only accepts a handfull of
constants. Is there any way to use an actual date for this?
Sample code:
With Application.FileSearch
.NewSearch
.LookIn = "C:\"
.FileType = 1
.TextOrProperty = "*Test*"
.LastModified = msoLastModifiedYesterday
.Execute
If .Execute() > 0 Then
MsgBox "There were " & .FoundFiles.Count & _
" file(s) found."
Else
MsgBox "There were no files found."
End If
End With
I want to change the .LastModified property to look
something like this:
.LastModified > "#01/01/2004#"
Is there another way?
Thanks,
The Ben