I have an Access Database including a number of nice reports. Unfortunately when I use the standard OfficeLinks in Access to export the report as an excel sheet I loose the charts in the report (receive only the text parts of the report).

Any idea of how to copy a specific chartobject from an access report into an excel sheet, preferable in a programatical way (VBA/Macro)

Hope for help