Exporting Access Pivotchart to Excel

[sanniep]

Dear Expert,

I would like to program a button to export an Access pivotchart to Excel. The predefined button works ok but I would like to automate it.

Thanks, Sander

[willakawill]

Dear Expert,

I would like to program a button to export an Access pivotchart to Excel. The predefined button works ok but I would like to automate it.

Thanks, Sander

OK great. Post the code that you have and let us know what part of it you would like to change
Thanks