I want to add a 'browse for folder' button that will open a dialog allowing the user to browse + choose a folder, and return its filepath.
There are many such scripts available, and I have tried several, but not found one that includes both of these features in one:
- includes a 'Create New folder' button for the user.
- the function should have an input parameter allowing me to set or highlight the starting or 'initial' folder for the user. (This is not the same as a Root folder, and should not block user from navigating up or out).
About the closest I came is a script from here:
I zipped and attached my version here.
It allows EITHER of the above mentioned features, but not both at same time!
When choosing the 'CreateNewFolder' option it shows a nice, large dialog that is positioned way off at bottom right (on my computer), not fully showing. Needs to be dragged to be used.
And, it does not allow me to set an initial starting folder.
The other option allows me to set an initial starting folder, but then no more 'new folder' button! Also it produces a smaller, not so easy to navigate dialog, although this one is at least centered correctly.
I did find one script that SAYS it does everything: http://www.vbaccelerator.com/home/vb/Code/Libraries/Common_Dialogs/Folder_Browser/article.asp
But, it is very long complex code, containing many modules. I, a newbie, could understand nothing, nor get it to run. The page claims only 2 of the modules are needed, and could be added to my app. But I was completely lost in trying that.