Add-ins, Templates, Wizards, and Libraries

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Creating a Microsoft® Office XP application is about enhancing and extending powerful applications that you and other users already have on your desktops. You can take advantage of the features in Microsoft® Word, Microsoft® Excel, Microsoft® PowerPoint®, Microsoft® Access, Microsoft® FrontPage®, and Microsoft® Outlook®, as well as all the time and resources Microsoft has invested in developing and testing these applications, to build an application quickly and easily that meets users' requirements without requiring a lot of training and support.

One way to provide users with a custom application is to build an add-in. An add-in extends an application by adding functionality that is not in the core product itself. If you are a frequent user of Excel or Access, you might already be familiar with some of the add-ins that these applications include. For example, the Linked Table Manager in Access is an add-in that was built in Microsoft® Visual Basic® for Applications (VBA).

You can create two different types of add-ins: Component Object Model (COM) add-ins and application-specific add-ins. COM add-ins can work in more than one of the Office XP applications.

The other type of add-in you can create is an application-specific add-in. You can create application-specific add-ins in Office XP, as well as in previous versions of Office. An application-specific add-in works in only one application.

Another way to distribute a custom Office application is to create a template. A template provides the user with a basis for creating a new document. For example, a Word template might include the basic layout for a report that an employee can use to create a new document with the same layout and simply fill in the new information.

In addition to the add-ins and templates mentioned earlier, you also can create two specialized kinds of add-ins: wizards and code libraries. Wizards are add-ins, and they help users through a complex process step-by-step. Code libraries are add-ins in which you can store frequently used procedures and generic code. By setting a reference to a code library, you can call procedures stored within that library from your current VBA project.

In This Section

  • 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 Office Applications
    By building COM add-ins, you can 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.
  • Developing Office Applications Using VBA
    Create Microsoft® Office XP applications that can range from writing a simple Microsoft® Visual Basic® for Applications (VBA) procedure to creating a sophisticated financial analysis and reporting application
  • The Benefits of Office Programmability
    Quickly and easily build and deploy custom desktop applications and take advantage of the objects exposed by Microsoft® Office XP applications, so your custom applications can leverage existing, proven, and tested Office functionality.
  • Office Objects and Object Models
    Integrate the features from two or more Microsoft® Office XP applications into a single application to amplify and focus users' productivity.
  • Working with Office Applications
    Take advantage of different objects, collections of objects, properties, methods, and events to build your application.
  • Working with Shared Office Components
    Search for files, use the Office Assistant, manipulate command bars, read and write document properties, read and write script, and hook add-ins to your Microsoft® Office XP application using a set of shared objects available in all Office applications.
  • Getting the Most Out of Visual Basic for Applications
    Write code that is fast, efficient, easy to read and maintain, and, if possible, reusable with a solid working knowledge of Microsoft® Visual Basic® for Applications (VBA) — what features the language includes and what you can do with it.