Filename and path
 

How do I allow a user to select the filename they want to import? I want the
user to start a macro and get a file open dialog. I then want to save that
path and filename to a variable. I will then ask some questions of the user
and use their value to import their selected file.

Thanks
Mike

Filename and path
 

I guess I gave up too fast.

Answered here -
http://www.exceltip.com/st/Use_the_b...Excel/416.html

"Mike" wrote:

How do I allow a user to select the filename they want to import? I want the
user to start a macro and get a file open dialog. I then want to save that
path and filename to a variable. I will then ask some questions of the user
and use their value to import their selected file.

Thanks
Mike