If the situation is that it is always this year and last year as an example,
have the user choose the file name, then open that filename from each
folder.

nm = InputBox("Enter filename")
sStr1 = "C:\2006\" & nm
sStr2 = "C:\2005\" & nm

Note that you can't have two files open with the same name, so you would
have to work with them sequentially.

--
Regards,
Tom Ogilvy



"MSHO" wrote in message
...
Hello

I am trying to write a macro that prompts the user to choose 2 files to
open. The problem is that the files have the same name, but they are
located
under two different folders. (The folders are different years, the files
are
of the same type with different data.) I really don't want to go back and
change all the names of the files. Is there a way to search within
different
folders?

Thanks