I am currently creating an automated process to export an Access query data to Excel, create a pivot table and pivot chart and update an Access report. Till now I managed to get to the point where in Excel I have the Pivot Chart exactly as I require. All I need now is to copy that chart and paste it into the Access report in the 'Detail' section, automatically of course. I know how to copy the chart in Excel through VBA, but dunno how I can code the pasting into the Access report.
I am assuming that I need to open the report in design view using the "DoCmd.OpenForm "Compliance_Report", acDesign" command but I can't figure out how to do the 'paste'.
Any help greatly appreciated of course!
Thanks
I am assuming that I need to open the report in design view using the "DoCmd.OpenForm "Compliance_Report", acDesign" command but I can't figure out how to do the 'paste'.
Any help greatly appreciated of course!
Thanks