search by date in windows explorer

B

boyd

if i have 100 individually saved excell invoices, and i want to search by
dates and the format of those dates are as follows (1/1/2002) is there a way
to search by months
 
S

shafiee

You can create a hidden cell which extracts the month from the date, and
then use that to search by months. You can do this by using the following
formula:

=TEXT(A1, "mmmm")

That will give you the month in text, which you can use in the "A word or
phrase in the file" box of the search assistant.

Hope that helped.

Shafiee.
 
B

boyd

OK I FOLLOW YOU SHAFIEE, BUT LETS SAY THAT FOLDER CONTAINS NOT 100
INDIVIDUALLLY EXCEL FILES INVOICES BUT RATHER 3000 DO I HAVE TO DO THAT ONE
BY ONE OR IS THERE A WAY TO CREATE A MACRO THAT CHANGES ALL IN ONE SHOT.
THANKS FOR YOUR HELP THOUGH. THIS WAS A STUPID DECISION ON OUR PART TO SAVE
THIS WAY
 
S

shafiee

Yes there is.
Use this example

Sub Start()

'Enumerate the excel files

a = Dir("c:\invoicepath\*.xls")
Do
If a <> ActiveWorkbook.Name Then
ProcessFile a
End If
a = Dir
Loop Until a = ""
End Sub

Sub ProcessFile(filename)

'Do stuff with each individual sheet of each individual file

Set wbk = Workbooks.Open(ActiveWorkbook.Path & "\" & filename)
For Each sh In wbk.Sheets
sh.Range("A2").FormulaR1C1= "=Text(A1, " & chr(34) & "mmmm" &
chr(34) & ")"
Next sh
wbk.Close

End Sub

Oh and chill out dude.

Shafiee.
 
Top