Chapter 18. Controlling Other Office Applications

Excel's primary purpose is to perform calculations. It has some database-like 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 dedicated Office application—Access, ...

Get Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® 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.