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: 381
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
"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
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 11:00 AM.


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