I have an Access database that exports data to Excel, where we have a complex spreadsheet already set up with associated charts. Excel takes the data and does it's thing, then I import the spreadsheets back to Access where I use them with a formatted report and it works beautifully.

My problem is the 3-D bar and 20th Century pie charts we are using. I use the unbound object to pull in a graphic but it look TERRIBLE. Color is often lost, lines are distorted, and shadows show up as dots.

I found that if I link a Word doc to those Excel objects, then copy/paste to Access, they look muchmuchmuch better. So how do I automate this?

I'm a newbie to VBA code so I need more than just a direction here...please help.

Thank you.