O'Reilly logo

Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel, VBA, and .NET, Second Edition by John Green, Stephen Bullen, Dennis Wallentin, Rob Bovey

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 25. Writing Managed COM Add-ins with VB.NET

Chapter 23, “Excel and Visual Basic 6,” demonstrated how to create unmanaged COM add-ins using the add-in designer. In this chapter we perform the same task using VB.NET and its Shared Add-in Template. This template is the natural successor to the add-in designer in Classic VB. To use the code examples presented in this chapter you need Visual Studio 2008 Standard or higher and Excel 2003 or later. The Ribbon user interface examples require Excel 2007.

A cornerstone of modern, object oriented programming is the use of classes. Class modules were intentionally ignored in the preceding chapter, but we introduce them here. We also briefly discuss setup packages, which are automatically created when ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required