search by date in windows explorer
 

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

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.

"boyd" wrote in message
...
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

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

"boyd" wrote:

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

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.


"boyd" wrote in message
...
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

"boyd" wrote:

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