Windows Common Dialogs in VBA?

Discussion in 'Microsoft Excel Programming' started by Leonard Jonas, Jul 22, 2003.

  1. I'm writing a series of excel macros for sound processing and would like
    to present the user with a FileOpen common dialogue so that they can
    select a wave file to take data from.
    In VB I would use Project|Components... to add the control for the
    windows common dialogue. In VBA there is no such menu item. There is a
    Tools|Add Controls... item, but it is deactivated. I can load the add-in
    manager, but it doesn't have any add-ins to chose from.
    Anyone know how I might get myself a common dialogue control in VBA?

    Thanks
    Lenny

    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
     
    Leonard Jonas, Jul 22, 2003
    #1
    1. Advertisements

  2. Leonard Jonas

    Bill Lunney Guest

    Load

    vFilename = Application.GetOpenFilename(Title:="Enter file name",
    MultiSelect:= False)

    Save
    vFilename = Application.GetSaveAsFilename(Title:="Enter file name",
    InitialFileName:="")

    http://www.billlunney.com/Excel/FAQ/DisplayFAQ.ascx?ExcelFAQID=71


    --

    Regards,


    Bill Lunney
    www.billlunney.com

    "Leonard Jonas" <> wrote in message
    news:...
    > I'm writing a series of excel macros for sound processing and would like
    > to present the user with a FileOpen common dialogue so that they can
    > select a wave file to take data from.
    > In VB I would use Project|Components... to add the control for the
    > windows common dialogue. In VBA there is no such menu item. There is a
    > Tools|Add Controls... item, but it is deactivated. I can load the add-in
    > manager, but it doesn't have any add-ins to chose from.
    > Anyone know how I might get myself a common dialogue control in VBA?
    >
    > Thanks
    > Lenny
    >
    > *** Sent via Developersdex http://www.developersdex.com ***
    > Don't just participate in USENET...get rewarded for it!
     
    Bill Lunney, Jul 22, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Stratuser

    Using Dialogs Save

    Stratuser, Jul 22, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    254
    Stratuser
    Jul 22, 2003
  2. Chip Pearson

    Re: compile error in hidden module: Dialogs

    Chip Pearson, Aug 14, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    225
    Chip Pearson
    Aug 14, 2003
  3. marc lagel

    compile error in hidden module: Dialogs

    marc lagel, Aug 14, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    264
    marc lagel
    Aug 14, 2003
  4. Jules

    application.dialogs(xlDialogSaveAs) AND CHDIR

    Jules, Sep 2, 2003, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    774
    Tom Ogilvy
    Sep 3, 2003
  5. Guest

    MS Windows Common Controls-2 6.0 (SP4) using VBA in Excel

    Guest, Aug 8, 2007, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    919
    Guest
    Aug 8, 2007
Loading...

Share This Page