Link to home
Start Free TrialLog in
Avatar of Madeso
MadesoFlag for France

asked on

Need to use a dialog box showing a view of explorer in which I would be able to select a directory (without any file)

Hi,

Access-VBA
I need to get a full pathname of a directory by using a dialog box which would show a view of the explorer ... kind of SaveAs common dialog box but without having to select a file just the folder/directory and then stored the pathname into a parameter table. I saw the same question but for another topic area ..., thanks for help !

ASKER CERTIFIED SOLUTION
Avatar of nffvrxqgrcfqvvc
nffvrxqgrcfqvvc

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ryan Chong
Avatar of Madeso

ASKER

Great! Working perfectly!
Thanks for help and for a so quick answer !
Avatar of nffvrxqgrcfqvvc
nffvrxqgrcfqvvc

Madeso, I forgot to mention that to get a list of My Computer, and all other special folders just remove the specified path.
Lists mycomputer,mydocuments etc...
Set objFolder = objShell.BrowseForFolder(0, "BROWSE FOLDER", 0, vbNullString)

The below code will just list the C:\ drive
 Set objFolder = objShell.BrowseForFolder(0, "BROWSE FOLDER", 0, "C:\")