Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    Common Dialog Control (2000/XP)

    The Commondialog control is available in Excel to add to a user form however I am unable to access any of it's properties or methods via code. Thoughts?

    Thanks
    Ed

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Common Dialog Control (2000/XP)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Ed

    Could you be a bit more detailed as to what properties or methods of what control are you trying to access via code?

    Is it one of the buit-in controls, or an Active-X third party, or what have you, such as the calender control?

    Can you give a short but detailed explanation as the code is trying to do? Any error messages?

    Can you give a short but detailed explanation as to what you are trying to do?

    Thanks...

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Common Dialog Control (2000/XP)

    Documentation is available on MSDN: Using the Common Dialog Control. Make sure to view the subordinate items (see the left hand pane, or click 'See also'.)

    BTW, I hope that you are aware of the Application.GetOpenFilename and Application.GetSaveAsFilename methods built into Excel, as well as the Application.Dialogs collection with members such as xlDialogOpen, xlDialogPrint etc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •