Are you looking in one directory or multiple directories? The DIR() function
may work. I need more details on your search to give you the right answer. I
have lots of code that does File Searches without the File Search function.
Are you just looking for names of files or are you looking at the dates as
well? I should be able to quickly give you the right code when I get the
details.

"Fawn" wrote:

I am in an excel class for school. We are learning out of an excel '03 book,
yet I have an '07 program. As part of my studies I am use the "File Search"
command. I used the interactive excel program and it stated that the '07
does not have this command. Yeah, I need help. I cannot finish this program
w/out this command. I need to use this to find 3 previous files created and
put them all into one new workbook