CHAPTER 8Office Integration

One of the really great things about VBA in Microsoft Office is that it allows programmatic access to each application from the others. This powerful functionality lets us automate many business processes, including data integration and document creation and management. It also allows us to create workflows within the Office suite of applications.

In this chapter, we will see how we can turn an Excel workbook into a summary report in Microsoft Word. We'll also take that same workbook and create a presentation in Microsoft PowerPoint. Both documents will include text and chart data from our Excel project.

The code we've been writing so far has accessed properties of Microsoft Excel 2007 using the Excel Document Object ...

Get Pro Excel 2007 VBA now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.