Anyone know how to automate embedding charts from Word to Access report?

[djrickel]

We have an Excel spreadsheet with numerous 3-D chart objects, mostly the 21st Century pie chart but also other bar charts. I need to embed those objects into an Access report but the shadows show up as dots and lines are jagged. I found that linking the charts to a Word doc first, then embedding them into the Access report works best with little distortion. I need this automated but can't figure out how.

1) Is there a way to use the 21st Century pie chart in Access so I can avoid all those steps?

3) If not, can you give me an idea of the code to use to automate the move from Word to the Access report?

Thanks!

[NTC]

if these are to be true dynamic charts - meaning that the display changes as the data changes - - then they must generate out of Access based on the data and one would not use any source such as Excel or Word for the image of the chart.

but if these charts are static, then essentially they are just images. And if they are images then the key is to get that image file in a format most useable inside access - which is typically bmp, jpg or png rather than Word or Excel. When one is encapsulating an image with an Access report you want high definition with as small file size as possible. If you think about it, Word and Excel (and Adobe) really are not images - they are full blown application files with lots of other capabilities. So it is tough sometimes to encapsulate them just for an image. So getting those images in more of a pure image file format may be the key to getting a better display.