Found back the link For Excel2K :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl10/html/xlmthpivottablewizard.asp


>Thanks.
>
>Also I used to follow the VBA Help, where for dialog.show they wrote:
>"To find the arguments to set, locate the corresponding dialog box constant in Built-In Dialog Box Argument Lists. "
>
>So for xlDialogPivotTableWizard there are only 10 arguments (I am in Excdel97 at this moment). I see that you are using 16 arguments, and it works. So, how/where do you find the proper syntax?
>
>
>
>>Got that from MSDN... but I can't find the link anymore :\
>>
>>anyway, it stated that if you use the external data, you NEED to give the SELECT statement[2nd argument], which in my case is left blank to let the user make his selection, and the ODBC Connection String [Last Argument].
>>
>>With that properly formated, it works exactly as I wanted it.
>>
>>
>>
>>>Good to know. How did you find the mandatory arguments? (I suspect it is why I was not able to use Show with arguments previously.)
>>>
>>>
>>>>I finally got it to work...
>>>>
>>>>There it is :
>>>>
>>>>

>>>>#DEFINE xlDialogPivotTableWizard 312
>>>>#DEFINE xlExternal  2
>>>>
>>>>DIME gaSelect[1]
>>>>gaSelect[1] = ""
>>>>lcODBCConnexion = "ODBC;DRIVER=SQL Server;SERVER= YourSQLServerName;UID=YourLogin;PWD=YourPassword;APP=Microsoft Visual FoxPro;DATABASE=DBName"
>>>>
>>>>oXL = CREATEOBJECT("Excel.Application")
>>>>oWB = oXL.Workbooks.add()
>>>>oSheet = oWB.ActiveSheet
>>>>oXL.visible = .T.
>>>>oDialog = oxl.Dialogs(xlDialogPivotTableWizard)
>>>>
>>>>oDialog.Show(xlExternal, @gaSelect,,,,,,,,,,,,, .T., lcODBCConnexion)
>>>>

>>>>
>>>>
>>>>for External DataSource, the 1st, 2nd, and last parameters are mandatory.
>>>>
>>>>Have a nice day,
>>>>
>>>>Yanick
>>>>>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?