OutputTo Report to Excel - Chart not shown in Excel - Why?

R

Robert G

Hello,

I am using the following code to send a report to excel

DoCmd.OutputTo acOutputReport, BerichtName, acFormatXLS, PfadDatei, False

I then call up

Retval = Shell("C:\Programme\Microsoft Office\Office10\EXCEL.EXE " &
PfadDatei, 3) ' Open the Excel file.

All this works perfect, so I do not need help here. Where I need help is
the following.

The report which is sent to Excel holds a pivot chart and the chart is not
listed within the excel file. Can some one tell me how I am able to export
the charts to excel as well?

Any help is very appreciated.

Thank you!

Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Unreadable text when viewing organization chart in Web version of Visio 365 0
Excel freezing after sharing document by Email 0
Embed the same Excel multiple times 0
Integrating information from Word to Excel (not mail merge) 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Visio 2010 Pro not showing Org Chart menu 0
Is ExecuteExcel4Macro still works in Excel 2013 or later version? 1

Top