dialog for directories
 

Hello,

I'm trying to find a diolog which allows a user to select a directory.
Right now I'm using the "Application.GetOpenFilename(...)" Dialog but
the problem is that I can only select filenames but no directories.

Thanks a lot,
Mibi

dialog for directories
 

Mibi,

See http://www.cpearson.com/excel/browsefolder.htm for some
example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




wrote in message
om...
Hello,

I'm trying to find a diolog which allows a user to select a
directory.
Right now I'm using the "Application.GetOpenFilename(...)"
Dialog but
the problem is that I can only select filenames but no
directories.

Thanks a lot,
Mibi