I have been an avid reader of this forum and have gotten many ideas from the
discussion. I am glad I joined. I need some help and THANKS in advance to
everyone who will reply to this.

Here is my problem:
-------------------------
I am creating an application in Excel VBA. I currently have a toolbar with a
button that starts the application. In this application, I want to ask the user
to create an Excel file in a location of their choice.

Currently, I am using an Inputbox and they can type the full path, and I can use
this path to create the file.

I would like to do the following. WHen then click on the particular button on
the toolbar, I would like a dialog box to open where they can select a directory
and then type a name.

How can I do this?