Macro: Pivot table to Excel

[DajOne]

I created a macro that opens a query, which updates a table from which the data of a Pivot Table Form is taken. I can have the 'openform' macro command work but I need the macro to:

Open the pivot table in Excel (double click on the form?)
Close the access pivot table form..

I cannot figure it out.. any help would be appreciated.

Also... If someone can figure out a way for Access to remember the parameters of a make table query to pass through a pivot table form to end up in Excel cells.. I would appreciate!!!. (I read everywhere it is impossible but why not ask...)

Thanks in advance

 

[PHV]

Have you tried a crosstab query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[DajOne]

The cross tgab query does not allow enough flexibility for my report.,... unfortunately.. but thanks anyway!!!