Microsoft Office Forums Use an "open" dialog box for selecting directories

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-28-2005, 03:38 PM
rnstewart rnstewart is offline
Novice
Use an "open" dialog box for selecting directories
 
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
  #2  
Old 11-28-2005, 06:24 PM
Matrix's Avatar
Matrix Matrix is offline Use an "open" dialog box for selecting directories Windows 7 32bit Use an "open" dialog box for selecting directories Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 396
Matrix is on a distinguished road
Default

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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Use an "open" dialog box for selecting directories "IF" "THEN" statements in Macros mfgeng_iss Misc 0 10-04-2007 07:31 AM
Use an "open" dialog box for selecting directories "open" or "open using" option not availa ccd Outlook 0 09-22-2006 01:23 AM
Use an "open" dialog box for selecting directories 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 10:03 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft