Limit FileSearch to Files of certain date?
Hi RB,
The following code, taken from the PropertyTests Collection Object entry in
Word VBA Help, might point you in the right direction.
Set fs = Application.FileSearch
fs.NewSearch
With fs.PropertyTests
.Add Name:="Files of Type", _
Condition:=msoConditionFileTypeWordDocuments, _
Connector:=msoConnectorOr
.Add Name:="Last Modified", _
Condition:=msoConditionAnytimeBetween, _
Value:="1/1/96", SecondValue:="6/30/96", _
Connector:=msoConnectorAnd
End With
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
Word FAQs at http://www.multilinker.com/wordfaq
Please post any follow-up in the newsgroup. I do not reply to Word questions
by email
Quote:
>Hi Jonathan,
>Yes, you are right. I was still passing it as a date.
>Still this solution is not ideal. I am not interested in the text, just the
>properties. Looking at the text slows the macro down a lot. Is there no way
>I can search the files with a particular date in the property?
>Thanks for the help.
>RBS
