How to Show a Directory dialog ?

Ido
03-20-2003, 07:51 AM
Hi,

I'm working in Excel, writing a macro.
How can i show the user a dialog to choose a directory from?
I know how to choose a file, but didn't find how to choose a directory.
Is there such a control ?

( It's maybe not just related to VBA )

Thanks.

OnErr0r
03-20-2003, 09:03 AM
You call SHBrowseForFolder api

Ido
03-20-2003, 11:50 AM
Thank you very very much !!

Mill
03-20-2003, 11:58 AM
I give an example of this in my FAQ thread here:

http://www.visualbasicforum.com/showpost.php?postid=220659&postcount=6

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum