If you do file|open, you can click on search (it's under Tools in xl2002).

Maybe you could search there and see if that helps. But if I put 08/19/2004 in
a cell (formatted for dd-mmm-yy) and then search for 19-aug-04, it didn't find
it.

Maybe you could search for the same format as your pc's short date format.

If you're not tied to VBA, maybe you could use Windows start button|search to
find it.



"Michael Wise <" wrote:

Thanks Dave,
But I have tried the format(dd-mmm-yy) did not work it caused it to
bypass all together. The file it is searching is still in text form and
so the date represented within that files date is formated dd-mmm-yy. I
have even tried assigning a variable as well did not work there either.

Other suggestions?

Michael

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson