firefly2k8
Registered User.
- Local time
- Today, 06:22
- Joined
- Nov 18, 2010
- Messages
- 48
On the double click event of chart view I have:
Me.PivotTable.Export "D:\filepath\test.xls", plExportActionOpenInExcel
But this does not give me the chart, just the pivot table and data. It also gives the error "Problems during load".
Doing:
Me.ChartSpace.ExportPicture "C:\yourdirectory\filename.gif", , 1024, 1024
works if you want an image. I would like the chart in excel so that users can make changes.
Should I just give up trying to export access charts to excel?
Me.PivotTable.Export "D:\filepath\test.xls", plExportActionOpenInExcel
But this does not give me the chart, just the pivot table and data. It also gives the error "Problems during load".
Doing:
Me.ChartSpace.ExportPicture "C:\yourdirectory\filename.gif", , 1024, 1024
works if you want an image. I would like the chart in excel so that users can make changes.
Should I just give up trying to export access charts to excel?
