Using a Dialog To Change Directory

[Janie]

I have used the FileOpen Dialog described in Knowledge Base article 303066
many times. But now I am trying to just collect a PATH, not a file name to
open. The path will be used to Export some files. Since the needed path may
not be the CurDir, I'd like the user to be able to navigate to the wanted
folder and have the path recorded in a TextBox.

Can the FileOpen dialog be adapted somehow? Is there already a utility out
there I just haven't found the magic words to bring up?

As always, thanks for any pointers anyone may have.

 

[Stuart McCall]

I have used the FileOpen Dialog described in Knowledge Base article 303066
many times. But now I am trying to just collect a PATH, not a file name
to
open. The path will be used to Export some files. Since the needed path
may
not be the CurDir, I'd like the user to be able to navigate to the wanted
folder and have the path recorded in a TextBox.

Can the FileOpen dialog be adapted somehow? Is there already a utility
out
there I just haven't found the magic words to bring up?

As always, thanks for any pointers anyone may have.

Try using the folder dialog instead:

http://www.smccall.demon.co.uk/MiscApi.htm#SelectFolder

Textbox.Value = SelectFolder("Please select the export location")

 

[Dale Fye]

Janie,

The first place I check for stuff like this is: http://www.mvps.org/access/

As with Stuart's link, there is an api listed on that site for browsing the
folders.

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.