Check out Application.GetOpenFilename in the Help

NickHK

"surelystumped" wrote in message
...
I wrote macros in Lotus and we are currently switching over to Excel but
I
can't find the command that will allow the user to input the name of the
file
to open and get the data from the file. I have it set up to open a file ,
copy a range , close the file and paste it in the current worksheet but it
works for a hard coded file. I need to be able to input the name of the
file
to get the data from. Can anyone help me? You can reach me at tow emails
address. The lone attached to this name and Thanks.