p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Excel VBA (http://p2p.wrox.com/forumdisplay.php?f=79)
-   -   file search method (http://p2p.wrox.com/showthread.php?t=34870)

esfaryn November 4th, 2005 04:14 AM

file search method
From what i understand about File Search, the program will pick out the file name that contains the word/phase. However, what if all the files contain the same word/phase?

An example of different file names:
(1) "happy_work_009"
(2) "happy_tuesday_work_001"
(3) "happy_monday_work_001"
(4) "wednesday_work_005"

So basically, I want to retrieve all files that contains just the word "happy"? How do i search for a file in a directory?

And also, how do i condition the file search not to go thru the files whose size are 0kb and also to retrieve file from a period of time using msoConditionAnytimeBetween property??

Im using the vba to write the codings out. need urgent help please?


fs = application.filesearch
fs.lookin = directory
fs.filename = variable & "??????????????.dat"
With fs.PropertyTests
        .Add Name:="Last Modified", Condition:=msoConditionAnytimeBetween, _
             Value:=Format(dt1, "dd MMM yyyy"), _
             SecondValue:=Format(dt2, "dd MMM yyyy")
end with

Best Regards,
Farina =P

All times are GMT -4. The time now is 11:56 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.