Automatically Exporting to Excep

[wazawak]

I am trying to create a single button that will open up a PivotTable form I have created and export it to Excel, but I don't know how to do it. I suspect a VBA command will do, or possibly a macro, but I am inexperienced with either of these and don't know where to begin.

I have already created the PivotTable in Access and just need to add in that extra bit of user-friendliness for the old dog who doesn't want to learn any new tricks.

 

[ajetrumpet]

A pivotTable is just another display tool in Access, so couldn't you use the docmd.transferspreadsheet method in VB to export the underlying recordset behind the form I wonder?

Excel has the Pivot Table function too...are you trying to export the actual object over to Excel?

 

[wazawak]

Yes, I am trying to have Excel open up the actual PivotTable. A lot of people are familiar with Excel and prefer to work with it instead of Access.