View Single Post
 
Old 11-28-2005, 03:38 PM
rnstewart rnstewart is offline
Novice
 
Join Date: Nov 2005
Posts: 6
rnstewart
Default Use an "open" dialog box for selecting directories

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:

Code:
Application.Dialogs(xlDialogFindFile).Show
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.
Reply With Quote