MS Office References

[Eileen]

Hi,

I am finding the task of finding complete reference information on the
various office dialog boxes like looking for a needle in a haystack. I would
like to see a reference for the various office programs that lists the
available dialog boxes and all elements pertaining to those boxes that can be
customized and the appropriate syntax for that element. For example
wdDialogFileOpen, wdDialogFileSaveAs, msoFileDialogSaveAs, etc. Does such a
reference exits? If so, where is it located?

 

[Jay Freedman]

What exists is a VBA help topic called "Built-in Dialog Box Argument
Lists", which you can find by typing that phrase into the Help search
box. For each dialog box constant in the WdWordDialog enumeration
(which covers most but not absolutely all the dialogs in Word), it
lists the arguments you can set or read for that dialog object.

For a very long time, we've complained that while this list is useful,
it's woefully insufficient. It does not indicate the data type or
valid values for any of the arguments, nor does it explain which
argument corresponds to which dialog control. Also, some dialogs have
controls for which there is no corresponding argument, and some of the
arguments are there but don't have any effect.

It's extremely imperfect, but it's what we have.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.

 

[Eileen]

Thank you for the info, Jay.