Ask user a file name
 

Hello,

I need to write a macro that asks the user the name of a excel file and then
copy a sheet of it into a new workbooks without opening the file.

I already start with this piece of code, but I do not know how to use the
file name:

file= Application.GetOpenFilename(FileFilter:="Excel Files (*.XLS), *.XLS", _
Title:="Select File To Be Opened")
If file = False Then _
Exit Sub

Thanks

Ask user a file name
 

You have to open it, no question about it. GetOpenFilename returns the
selected filename with full path which you can use to open the file, do your
copy, then close it.

--
__________________________________
HTH

Bob

"Lucile" wrote in message
...
Hello,

I need to write a macro that asks the user the name of a excel file and
then
copy a sheet of it into a new workbooks without opening the file.

I already start with this piece of code, but I do not know how to use the
file name:

file= Application.GetOpenFilename(FileFilter:="Excel Files (*.XLS),
*.XLS", _
Title:="Select File To Be Opened")
If file = False Then _
Exit Sub

Thanks