The Microsoft Office Suite has a number of tools for communicating between
its products, the most powerful of which is Office Automation through VBA
(Visual Basic for Applications). By exposing the underlying object model for
each of its applications, Microsoft made it possible to exercise programmatic
control not only within a particular application, but between applications.

In my last article, Easy
Excel Charting from Access, I showed how to create Excel chart from
Access. The charting capabilities of Access using MS Graph are fairly primitive,
so by sending the data to Excel, I can have a much richer set of charting tools.
However, what I never covered is what to do with charts once they've been
created.

It would be useful to paste these charts into an Access report, but that's
not possible. However, it is possible to programmatically create a Word
document, write data from your database to it, and then paste the appropriate
chart into the document, making Word a very powerful and flexible reporting tool
for Access.

Automation Program Overview

I create the Access subroutine (called ExcelWordAutomation), which
automates the process of creating the Word documents. The overall process goes
something like this:

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot delete your posts in this forumYou cannot edit your posts in this forumYou cannot create polls in this forumYou cannot vote in polls in this forum