Chapter 22. Controlling Other Office Applications

The primary purpose of Excel is to perform calculations. It has some databaselike features, but it’s not a relational database. It has some text editing and formatting features, but it’s not a word processor. It has presentation-quality graphics, but it’s not a presentation application. It can save worksheets as Web pages, but it’s not a Web-authoring tool. It can send a workbook through e-mail, but it’s neither an e-mail program nor personal information manager.

Excel’s built-in database, word processing, presentation, e-mail, and Web features are sufficient for most applications, but there comes a time when we need to use a feature that is only provided by the Office application dedicated to the ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.