Part IX: Integrating Excel and Other Office Applications
Summary
Every data-oriented process has an application flow - a succession of applications that take the data from creation to end-user. Sometimes a dataset is touched by only one application, such as when you're creating a report and presenting it in Excel. In many cases, however, data is moved from a database such as Microsoft Access, analyzed and aggregated in Excel, and then distributed through a Microsoft Word document, Microsoft PowerPoint presentation, or even e-mail. This chapter looks at some of the useful macros one can implement to have Excel integrate with other Office applications such as PowerPoint, Word, and Access.