Browse with imput box

[bhofsetz]

I want to use an input box in which the user could either type the path and file name for a file that is to be used in my code. i.e. the file which contains the data to be manipulated.
However if they don't know the exact path and file name I want to allow them to browse the hard drive to find and select the file required.
Is there any way to add a browse option to a VBA input box?

Thanks

[theDude]

Straight from the Visual Basic Help file topic FindFile:

FindFile Method Example

This example displays the Open dialog box.

Application.FindFile


Hope this helps,
theDude

[bhofsetz]

Thanks TheDude, exactly what I was after.

[silverh]

I was working on the same problem... my question is, what if I only want the path directory and not to open the file?

[Leith Ross]

Hello,

This is in response to Silverh's question...

Returning Only the Path from the Open Dialog Box:
MyPath = CurDir(Application.GetOpenFileName)

Sincerely,
Leith Ross

[silverh]

Thank you very much mr. Leith Ross.

[bhofsetz]

Leith,
Thanks. I can use that command as well.
Is there also an easy way to return just the file name given the full path. I have a function set up that looks backwards from the end of the full path and finds the first backslash but a one-line command would be cleaner in my code.

Thanks again

[bhofsetz]

FYI,
I found the command I was asking about in previous post.
Using:
Dir(FullPath)
without any attributes specified will give the file name with extension.