Dim fName as String
Chdrive "C"
Chdir "C:\Myfolder"
fname = Application.GetOpenFileName()

If ucase(fname) < "FALSE" then
Workbooks.Open fname

End if

See excel vba help on GetOpenFileName
for information on arguments you may use.

--
Regards,
Tom Ogilvy


Steve wrote in message
...
I have a macro that reads in a file. The file's name
changes every day when the date is appended. How can I
change my macro so that instead of always calling
MyFile.xls it prompts the user to type in the filename? I
can't make it call in MyFile_with_today's_date.xls because
sometimes I have to run the macro on old files.
Thanks