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.

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.

You might want a macro that the user can initiate with a keyboard control and
the macrow would display an input box that the user can enter a file name in,
or as an alternative the macro could display a checkbox with the file options
for the user to check. There are several options, look in the Help files for
InputBox Method and InputBox Function, also Create UserForm and then ListBox
and CheckBox. You can probably find what you need in one of these that will
make it easy on you and the user. When you decide what you want to try, if
you need assistance, re-post.

"surelystumped" wrote:

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.

Your advising against using Application.GetOpenFileName?

could you explain your reasoning?

--
Regards,
Tom Ogilvy


"JLGWhiz" wrote in message
...
You might want a macro that the user can initiate with a keyboard control
and
the macrow would display an input box that the user can enter a file name
in,
or as an alternative the macro could display a checkbox with the file
options
for the user to check. There are several options, look in the Help files
for
InputBox Method and InputBox Function, also Create UserForm and then
ListBox
and CheckBox. You can probably find what you need in one of these that
will
make it easy on you and the user. When you decide what you want to try,
if
you need assistance, re-post.

"surelystumped" wrote:

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.

haven't had a chance to try it yet will do in next few days thanks

"surelystumped" wrote:

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.

So far I am getting the results from opening the file and copying the range
into my active sheet. The only problem is all these windows opening and
shutting. I would like something less noticiable. I am still trying to make
the getopenfilename work...but so far not working

"surelystumped" wrote:

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.