Add-in Express

From Wikipedia, the free encyclopedia

There are very few or no other articles that link to this one.
Please help introduce links in articles on related topics. After links have been created, remove this message.
This article has been tagged since November 2006.

Add-in Express is a component set for Microsoft Office developers that allows extending Microsoft Office with custom functionality. It is designed for creating COM add-ins, smart tags, Excel real-time data servers (RTD servers), Excel Automation Add-ins and Excel user defined functions (UDFs) in a RAD way. Add-in Express builds its projects over special designers and components that make possible to develop add-ins, smart tags, RTD servers and UDFs without coding their graphical user interface (GUI), in that way lessening programming efforts in automation of MS Office objects and handling their events as well as in research, prototyping, and debugging.

The tool is developed for Microsoft Visual Studio .NET and Borland Delphi integrated development environments (IDEs).

Contents

[edit] History

Add-in Express was first released in 2002 as a VCL library for creating COM add-ins in Delphi. It hided all straits of low-level programming by implementing the IDTExtensibility2 interface and provided GUI management including the creation of command bars and command bar controls. At that time Add-in Express supported COM add-ins for five main Microsoft Office applications, namely Outlook, Word, Excel, PowerPoint and Access. Later Add-in Express started supporting FrontPage and Project. After Office XP had been published, the Smart Tags and Excel Real-Time Data servers technologies were added to Add-in Express. In 2004 Add-in Express was redesigned, and its second major version, Add-in Express 2.0, provided the RAD way for creating COM add-ins, smart tags and RTD servers. Also, one more technology, Excel Automation Add-ins, was added as well as the support of MapPoint, Visio and Publisher. Then Add-in Express was ported to .NET. In July, 2006 the VSTO (Visual Studio Tools for Office) edition of Add-in Express was released. Currently, Add-in Express is available in three editions: .NET, VSTO, and VCL. The current versions were released on October 30, 2006 and November 6, 2006. The next generation of Add-in Express, Add-in Express 3.0, is planned on December, 2006.

[edit] Supported technologies and applications

Add-in Express directly supports Microsoft Office 2000, 2002, 2003 and 2007, including:

  • Application-level COM add-ins (Component Object Model add-ins) for all main applications from the Microsoft Office family: Outlook, Excel, Word, Access, PowerPoint, Project, MapPoint, Publisher, Visio and FrontPage
  • Smart tags for Word, Excel, PowerPoint and Outlook (with Word as a default e-mail editor)
  • Excel Real-time data servers
  • Excel used defined functions
  • Excel Automation Add-ins

[edit] Supported IDEs

Add-in Express .NET works on the most popular IDEs available for .NET Framework 1.1 and 2.0, including Visual Studio 2003, Visual Studio 2005 and Borland Delphi for .NET. It directly supports:

Add-in Express VCL supports Delphi 5, 6, 7, 2005 and 2006 (including Architect, Enterprise and Professional editions).

Add-in Express VSTO supports Visual Studio Tools for Office 2005, Visual Basic .NET 2005 and Visual C# .NET 2005.

[edit] Main features

The main features that distinguish Add-in Express from other development components are:

  • A special module that implements the IDTExtensibility2 interface, provides access to objects and events of the add-in’s host applications, contains GUI components and centralizes the applied code.
  • Special designers that allow developers to create projects, GUI and logic of COM add-ins.
  • Effective deployment mechanism.
  • Support of auto-generated setup projects and shims. That is, shim projects are generated automatically when new solutions are created, and they are refreshed once the solution is changed.
  • Managed and unmanaged Office add-ons, including COM add-ins, smart tags, RTDs and UDFs.
  • Safe loading, unloading, separate and common application domains.
  • Easy programming model and the runtime support for all MS Office application objects and their events such as Outlook.NewMail, Word.DocumentBeforeSave, Excel.SelectionChange.
  • Extended features for Outlook, including option and property pages, folder and item level events.
  • Handling of smart-documents based on Excel and Word.
  • Shared add-ins, which means that any applications can be added or removed from the supported application list at any time.
  • Multi-add-ins projects. Several Office add-ins can be developed in one add-in project, in one assembly.
  • Office PIAs. Add-in Express directly integrates its projects with the Office primary interop assemblies which makes applied code smarter and more readable.
  • Command bars and controls. Special command bar components provide a flexible way to create controls on new or existing toolbars or menu bars, to replace any built-in toolbars with custom ones, to place custom controls and any built-in controls side by side on toolbars, menus and context menus.
  • Hooking and hacking. A special component embeds the code into event handlers of the built-in controls such as the Send button in Outlook, the Save menu item in Word, the Find command in Excel, etc.
  • Keyboard shortcuts in all Office applications. Add-in Express allows intercepting any keyboard shortcuts and using them for custom controls. Command bar components and keyboard shortcuts make possible to completely substitute any built-in controls with custom ones, e.g. the Save and SaveAs commands to store Office documents in the document management system.

[edit] Add-in Express extensions

Add-in Express is extended by a set of plug-ins that target different aspects of COM add-in development. The plug-ins focus on deeper aspects of Office windows and Outlook storage using the Windows API (WinAPI) and Extended MAPI technologies. Currently they include the ADX Extensions for Microsoft Outlook and the Toolbar Controls for Microsoft Office.

The ADX Extensions for Microsoft Outlook allows Outlook programmers to embed custom .NET forms into the Outlook Inspector and Explorer windows and use any controls on any Microsoft Outlook forms. The ADX Extensions gives Outlook developers the same advantages as the form regions technology supported by Microsoft Outlook 2007, but in contrast to VSTO 3 and Outlook 2007 this component works for all Outlook versions: Outlook 2000, 2002 (XP), 2003 and Outlook 2007.

The Toolbar Controls enables Office developers to use any visual .NET controls on Outlook and Excel command bars, including tree-views, grids, diagrams, edit boxes and reports.

[edit] External links

Retrieved from "http://en.wikipedia.org../../../a/d/d/Add-in_Express_003c.html"