Erlandsen Data Consulting

ERLANDSEN DATA CONSULTING

Excel & VBA Tips

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

User comments:

Alain from Belgium wrote (2006-01-25 13:53:35 CET):

Great example
Thank you for this code snippet!

Mack the Knife from Ireland wrote (2005-12-22 09:25:28 CET):

Fair Play
This got me out of a hole. Thanks!

Claus Hesselschwerdt from Karlsruhe, Germany wrote (2004-12-13 13:38:19 CET):

Careful with the flags - sometimes it works
The browseforfolder-flags depend on the installed version of shell32.dll and so it depends on the system, the office-version and the service-packs. Also it depends on the installed version of internet-explorer. In fact nobody can create a version-independent call of this api with same flags doing same things in same layout on variying systems. So, forget the flags.
Use CoTaskMemFree-Api to clear structure-memory after the call.

HansKey from Netherlands wrote (2004-08-31 20:02:15 CET):

SelectFolderNames
Thanks for the information

HansKey

Ole P. from Norway wrote (2004-08-30 12:55:04 CET):

Re: SelectFolderNames
Initially this code example is not suited to use a custom folder as the initial folder. The only useful change might be to limit the browsing to the users "My Documents" folder.
This can be done by changing
bInfo.pidlRoot = 0& ' Root folder = Desktop
to
bInfo.pidlRoot = 5& ' Root folder = My Documents

Other options for this setting:
0=My Computer
1=IE
2=Programs
3=ControlPanel
4=Printers
5=Personal (My Documents)
6=Favorites
7=Startup
8=Recent
9=SendTo
10=RecycleBin
11=StartMenu

You can however accomplish what you want by using a larger code example from VBnet, search for "BrowseForFolderByPath" and you'll find it.

HansKey from Netherlands wrote (2004-08-30 11:41:54 CET):

SelectFolderNames
Dear reader,

Great function, i have only a question.

With this dialog you get the root directorie of my computer, is it also possible to directly to a specified drive for example "P".

Thanks,

HansKey

SteveB from UK wrote (2004-07-12 09:49:16 CET):

SelectFolderNames
I have found lots of other versions on the web, but this is the first I've found that actually worked as is.

Thanks