-
Automate pasting graphics from Word to Access report?
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules