I want to create a file browser dialog box to allow the user to select a folder rather than a file (i.e., use the dialog box to generate a path). I know this is possible, and I suspect it's a standard option for Windows dialog boxes because I've seen it done fairly often in other applications. The only question is: is there an option for this in VBA?



I know I can easily create a "File Open" dialog box with the following code:

But this dialog only allows the user to select a file. Is there an option to modify this (or a totally different kind of dialog box) to select and return a path with no filename?

I'm running Office XP 2002.

There is no simple API to do this, please refer to the following page:
http://www.mvps.org/access/api/api0002.htm