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

Capturing a file path
 

See John Walkenbach's page on selecting a directory:

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

--
Regards,
Tom Ogilvy


"Daniel Bonallack" wrote in
message ...
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

Capturing a file path
 

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" wrote in
message ...
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