FYI,

Show does accept params... at least for some dialogs!

#DEFINE xlDialogSaveAs  5
oxl.Dialogs(xlDialogSaveAs).Show("FileName2Save")

>AFAIK, show method does not accept parameters.
>
>>Yuri,
>>
>>I'am already doing that, put for flexibility purposes I want to give my user the ability to Create/Define new Pivot that gets saved and that they can call afterwards with a simple click. I need both ways...
>>
>>Thanks anyway for your help.
>>
>>Still I need to pass params to the Show Method.
>>
>>
>>>Then you can create a pivot table with predefined properties, activate it and call the dialog from there. The very same way as it is allowed to do in Excel itself.
>>>
>>>>Actually I need to have the Dialog to let user interact with it...
>>>>
>>>>Anyone else?