Madeso
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 !
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Great! Working perfectly!
Thanks for help and for a so quick answer !
Thanks for help and for a so quick answer !
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:\")
Lists mycomputer,mydocuments etc...
Set objFolder = objShell.BrowseForFolder(0
The below code will just list the C:\ drive
Set objFolder = objShell.BrowseForFolder(0
http://vbnet.mvps.org/code/callback/browsecallback.htm
my example:
http://www34.brinkster.com/yshub/tmp/BrowseForFolder.zip