none
What are the arguments of Dialogs[XlBuiltInDialog.xlDialogPasteSpecial].Show RRS feed

  • Question

  • VSTO excel's pasteSpecial dialog takes 30 args. I've tried looking everywhere but can not find what each argument stands for.

    I am trying to set defaults for pasteSpecial when the dialogue pops up. (c# vsto2007)

    bool isPaste = Globals.ThisAddIn.Application.Dialogs[XlBuiltInDialog.xlDialogPasteSpecial].Show
                    (
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);

    Thursday, April 25, 2013 1:10 PM

Answers

  • Hi,

    Thank you for posting in the MSDN Forum.

    Those 30 arguments are optional. For more information on what they stands for, you can take a look into Dialog.Show Method (Excel).

    For built in dialog boxes, this method returns True if the user clicks OK, or it returns False if the user clicks Cancel.

    You can use a single dialog box to change many properties at the same time. For example, you can use the Format Cells dialog box to change all the properties of the Font object.

    For some built-in dialog boxes (the Open dialog box, for example), you can set initial values using arg1, arg2, ..., arg30. To find the arguments to set, locate the corresponding dialog box constant in Built-In Dialog Box Argument Lists. For example, search for the xlDialogOpen constant to find the arguments for the Open dialog box. For more information about built-in dialog boxes, see the Dialogs collection.

    Hope it helps.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, April 26, 2013 1:38 AM
    Moderator