MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

User input in creating a Excel Workbook

  Asked By: Zobah    Date: Nov 08    Category: MS Office    Views: 2282

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?



1 Answer Found

Answer #1    Answered By: Eamon Jones     Answered On: Nov 08

I'm not smart enough to give you the step by step details, but the
"GetOpenFilename" Method (which "displays the standard Open dialog  box and gets
file  name from the user  without actually opening any files.") sounds like what
you want.

Didn't find what you were looking for? Find more on User input in creating a Excel Workbook Or get search suggestion and latest updates.