7Customizing Excel with VSTO

Change is not made without inconvenience, even from worse to better.

—RICHARD HOOKER

Topics Covered in This Chapter

Programming in Excel

Excel Host Items and Host Controls

Data Binding to Host Controls on Worksheets

Programming Against Events

Making Excel Smarter

Summary

Review Questions

Programming in Excel

Many solutions developers use Microsoft Excel as a development platform because of its rich environment. You can take advantage of Excel’s powerful calculation engine, charting capabilities, customizable task panes, and extensive object model. VSTO enables rapid application development of Excel solutions by enhancing many of Excel’s objects, enabling quick development of smart tags and customized actions panes, ...

Get VSTO for Mere Mortals™: A VBA Developer’s Guide to Microsoft Office Development Using Visual Studio 2005 Tools for Office 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.