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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Stratuser

    Using Dialogs Save

    Stratuser, Jul 22, 2003, in forum: Microsoft Excel Programming
    Replies:
    0
    Views:
    336
    Stratuser
    Jul 22, 2003
  2. marc lagel

    compile error in hidden module: Dialogs

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

    application.dialogs(xlDialogSaveAs) AND CHDIR

    Jules, Sep 2, 2003, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    1,281
    Tom Ogilvy
    Sep 3, 2003
  4. =?iso-8859-1?q?Martin_S=F8rerensen?=

    Using common VBA code for a series of Woorkbooks.

    =?iso-8859-1?q?Martin_S=F8rerensen?=, Mar 1, 2006, in forum: Microsoft Excel Programming
    Replies:
    4
    Views:
    251
    Bob Phillips
    Mar 2, 2006
  5. Guest

    VBA compare two file paths and delete common root

    Guest, Jun 14, 2007, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    987
    Guest
    Jun 14, 2007
  6. Guest

    merge sheets based on common id with VBA

    Guest, Jun 18, 2007, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    468
    Tom Ogilvy
    Jun 20, 2007
  7. 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:
    1,290
    Guest
    Aug 8, 2007
  8. Guest
    Replies:
    3
    Views:
    1,725
    Chip Pearson
    Oct 12, 2007
Loading...