Building COM Add-ins for Office Applications
Because Microsoft® Office XP applications support the Component Object Model (COM) add-in architecture, you can use the same tools and installation file formats (a Microsoft® ActiveX® .dll or .exe) to develop add-ins for all Office applications. By building COM add-ins, you can extend the functionality of your Office-based applications without adding complexity for the user.
You can also create add-ins for Office Developer and for the Microsoft® Visual Basic® Editor. You can make such add-ins available to or from any application that supports Visual Basic for Applications (VBA), including applications other than Office.
In This Section
- Working with Add-in Designers
- Create and register your COM add-in with an add-in designer.
- Specifying Load Behavior
- Load (connect) the add-in, and make it available to the user; or unload (disconnect) the add-in, so it cannot be run.
- Writing Code in the Add-in Designer
- Begin writing code in the designer's class module when you have specified general information for a COM add-in in the add-in designer.
- Hooking a COM Add-in Up to a Command Bar Control
- Integrate your COM add-in (if it has a user interface) with the host application in some way, so the user can interact with it.
- Debugging a COM Add-in
- Load and use the COM add-in from within a Microsoft® Office XP application to test and debug it.
- Making the DLL
- Turn your COM add-in into a DLL when you have finished debugging it.
- Distributing COM Add-ins
- Install all the files necessary to distributing your COM add-in to other users on each user's system and register the add-in.
- COM Add-ins and Security
- Specify security settings for Microsoft® Office XP applications in the Office XP Security dialog box.
- Add-ins, Templates, Wizards, and Libraries
- Extend an application by adding functionality that is not in the core product itself by creating add-ins.
- What Is a COM Add-in?
- Extend the functionality of your Microsoft® Office-based applications without adding complexity for the user.
- Building COM Add-ins for the Visual Basic Editor
- Customize your development environment and work with components in a Microsoft® Visual Basic® for Applications (VBA) project from code.
- Building Application-Specific Add-ins
- Add functionality to Microsoft® Office XP applications by creating application-specific add-ins.
- Creating Templates
- Learn how to give users a framework within which to complete common tasks by using templates.
- Creating Wizards
- Understand how to create a wizard to walk users through a series of steps to create a new document, spreadsheet, presentation, database, or Web application and to deliver an application is that is easy to use.
- Building Reusable Code Libraries
- Increase your efficiency by storing code for functionality you often implement in your procedures.