Capturing a file path

I have a form with a button captioned "Change file path".
I want the user to be able to click the button, see a dialog box, and then
browse to a new location, and have the file path they went to before they
exit the form saved to a variable.

Is this possible?

Thanks in advance
Daniel

See John Walkenbach's page on selecting a directory:

http://j-walk.com/ss/excel/tips/tip29.htm

--
Regards,
Tom Ogilvy


"Daniel Bonallack" <[email protected]> wrote in
message news:[email protected]...
> I have a form with a button captioned "Change file path".
> I want the user to be able to click the button, see a dialog box, and then
> browse to a new location, and have the file path they went to before they
> exit the form saved to a variable.
>
> Is this possible?
>
> Thanks in advance
> Daniel

Thanks!

"Tom Ogilvy" wrote:

> See John Walkenbach's page on selecting a directory:
>
> http://j-walk.com/ss/excel/tips/tip29.htm
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Daniel Bonallack" <[email protected]> wrote in
> message news:[email protected]...
> > I have a form with a button captioned "Change file path".
> > I want the user to be able to click the button, see a dialog box, and then
> > browse to a new location, and have the file path they went to before they
> > exit the form saved to a variable.
> >
> > Is this possible?
> >
> > Thanks in advance
> > Daniel
>
>
>