#1
|
|||
|
|||
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 I'm running Office XP 2002. |
#2
|
||||
|
||||
There is no simple API to do this, please refer to the following page:
http://www.mvps.org/access/api/api0002.htm |
|
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 |