'Application.GetOpenFilename' only gets the filename but does nothing. The
second step is to

workbooks.open filename:= #### to open it.

"Rob Moore" wrote in message
...
I have been working on a macro that will prompt the user to select a file
and
then copy and paste (special values) that entire worksheet into a new
worksheet "old file". I have tried 'Application.GetOpenFilename' which
prompts me to select the file to copy but that file never opens up. Any
ideas.

Thanks,
Rob