CHAPTER 10
Interacting with Other Applications
Understanding Microsoft Office Automation
Throughout this book, you've discovered how to leverage VBA to automate tasks, processes, and program flow. In this chapter, automation will take on a different meaning. Automation here will define the means of manipulating or controlling one application with another.
Why would you even want to control one application with another? Data-oriented processes quite often involve a succession of applications. It's not uncommon to see data being analyzed and aggregated in Excel, used in a PowerPoint presentation, and then e-mailed via Outlook.
The reality is that each Microsoft Office application has strengths that you routinely leverage through manual processes. With...
