Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 11-28-2005, 03:38 PM
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
  #2  
Old 11-28-2005, 06:24 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 462
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
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 08:14 AM.


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