O
Oliver Scherf
I am using a chart object in an Access 2000 form. The chart should be
inserted into an excel file.
The current solution is based on the chart.export method: The chart is first
exported from Access to a .png file and than imported in Excel.
This works well except a very bad resolution of the imported picture in Excel.
Another option would be to copy the chart object in Access and paste it into
Excel.
Unfortunately the chart object has no copy method like e.g. the Excel chart
object.
Last try was to insert an Excel chart into Access. But I don't knwo how to
access it.
Is there anybody with an idea / similar problem ?
What is the best way to get a chart object from Access to Excel with good
quality?
Many thanks for your help in advance.
inserted into an excel file.
The current solution is based on the chart.export method: The chart is first
exported from Access to a .png file and than imported in Excel.
This works well except a very bad resolution of the imported picture in Excel.
Another option would be to copy the chart object in Access and paste it into
Excel.
Unfortunately the chart object has no copy method like e.g. the Excel chart
object.
Last try was to insert an Excel chart into Access. But I don't knwo how to
access it.
Is there anybody with an idea / similar problem ?
What is the best way to get a chart object from Access to Excel with good
quality?
Many thanks for your help in advance.