Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 11-28-2005, 03:38 PM
Join Date: Nov 2005
Posts: 6
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:

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
Old 11-28-2005, 06:24 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Join Date: Jan 2005
Posts: 468
Matrix is on a distinguished road

There is no simple API to do this, please refer to the following page:
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
"IF" "THEN" statements in Macros mfgeng_iss Misc 0 10-04-2007 07:31 AM
"open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM
Suppress "do you want to save?" dialog on close rnstewart Excel 2 12-28-2005 04:30 PM

All times are GMT -7. The time now is 06:32 PM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft