Common Dialog Control (2000/XP)

[edcarden]

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

[Wassim]

<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

[HansV]

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.