3. Programming Excel

Ways to Customize Excel

Excel is the application most frequently programmed against in the Office family. Excel has a very rich object model with 247 objects that combined have more than 5,000 properties and methods. It supports several models for integrating your code, including add-ins and code behind documents. Most of these models were originally designed to allow the integration of COM components written in Visual Basic 6, VBA, C, or C++. However, through COM interop, managed objects written in C# or Visual Basic can masquerade as COM objects and participate in most of these models. This chapter briefly considers several of the ways that you can integrate your code with Excel and refers you to other chapters that discuss ...

Get Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook now with the O’Reilly learning platform.

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