-
Link a word doc to excel how? Paste special, link keeping source formatting.
Copy what from Word? The Excel chart.
Paste it where in Access? To a report.
Your last paragraph says to use Excel to create the charts at the size that you want Access to display them, etc. which is exactly what I've been doing with awful looking results. The more 3-D the graphic, with shading and color variation, the worse it looks. Also, Access apparently only wants to grab part of a graphic if it is too large, which is too small for my purposes. Clip/Stretch/Zoom can't effect it when only part of the graphic is brought over.
Yeah, I get all the vector graphics stuff and that is WHY I'm trying to do what I described--because it works best and the quality of the graphic is maintained. Access' ability to create attractive charts is just plain basic and sad. I need better. I need 3-D but Access doesn't play well with 3-D. Word and Excel do. Excel to Access doesn't maintain quality when using the unbound object function. Excel to Access does with a copy/paste. Word to Access does with a copy/paste. Therefore, my answer is to find a way to copy/paste.
Let me boil down my question to this; how can I use VBA to copy/paste from Excel or Word to the Access report? I'm not a coder but I can manage if I'm given an example.
Thanks.
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