You could use the BrowseForFolder Windows API dialog instead. See
http://www.cpearson.com/Excel/BrowseFolder.aspx for details and
example code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com


On Mon, 12 Apr 2010 08:32:29 -0700 (PDT), Jerry
wrote:

I am using msoFileDialogFolderPicker for helping the users selected a
folder. I want the file name to be request.txt thus am giving the user
only to select the folder. Is there anyway i can hide the folder name
text box and force the users to double click and select the folder.

Few users think the folder name is file name and end up typing file
name and call support when it gives an error.