COM Addins

The VBE is common to all the Office 2007 applications, so it would be convenient to be able to create Add-ins for the VBE in a way that is not specific to a single Office application. In this chapter, you have created the VBE Toolkit as an Excel Add-in, with the result that the added functionality will only be available when using the VBE from within Excel. This was an appropriate choice, because the Add-in provides some Excel-specific functionality (such as opening and closing workbooks), but is a poor choice for the other functions you've added.

COM Add-ins provide a different way of extending the VBE and other Office applications, in a way that is not necessarily specific to a single application. By using a COM Add-in, you can create a single Add-in that targets the VBE specifically, and hence works across all the Office applications.

Chapter 18 explains how to create COM Add-ins.

Was this article helpful?

0 0
The Accidental Blogging Millionaires

The Accidental Blogging Millionaires

Get Inspired By The Most Popular Bloggers Online! If You Want To Skyrocket Your Success With Business And Improve Your Overall Life You Need To Have A Look At The Accidental Blogging Millionaires! Business can be a fight, particularly when you’re trying to establish one online and like all fights, to succeed you must find the winning techniques and apply them.

Get My Free Ebook


Post a comment