folder picker

[Jerry]

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.

 

[Chip Pearson]

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

 

[Jerry]

Thank you. If i follow the code in the link, it will not give the user
an option to create new folder. they will need to select the folder
already existing on their drive. How do i give them the option of
creating new folder?

 

[Jerry]

You could use the BrowseForFolder Windows API dialog instead. Seehttp://www.cpearson.com/Excel/BrowseFolder.aspxfor details and
example code.

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




- Show quoted text -

Thank you. How do I give the option to create a new folder by using
this code?