Using Microsoft Office as a development platform

Microsoft Office has traditionally been known as a powerhouse suite of largely standalone applications. With Office 2007, it has evolved into an application framework that exposes most of its functionality for external consumption as COM servers. This allows developers to build custom solutions, and now, with Office 2007, developers can use Office itself as a development platform.

Office works as a development platform, Andrew Whitechapel and John Peltonen write in What You Need to Know about Using Office as a Development Platform, because it simultaneously addresses basic application requirements and offers toolsets and extensibility points on top of that baseline functionality.

The key extensibility points, Whitechapel and Peltonen write in their MSDN article, are the Office object model and loose typing. The latter lets developers build add-ins with host-neutral code. On the plus side, this allows the add-in to run in any application that supports COM add-ins, regardless of the version. On the other hand, developers lose design-time or compile-time support for

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Microsoft Office Development Downloadable MSDN library released for VS 2008 SP 1 Check the MSDN Virtual Labs for regular, compelling new content Windows XP SP3 pack includes new XML parser, enhanced IP security Book excerpt: Building personalized solutions in SharePoint 2007 Book excerpt: Building document management solutions in SharePoint 2007 XAML as an everywhere presentation format Where are the Visual Studio 2008 Tools for Office? ClickOnce: Automated smart client deployment Book excerpt: SharePoint 2007 and content types Update desktops automatically using the AppUpdater component Visual Studio Tools for Office (VSTO) Where are the Visual Studio 2008 Tools for Office? Using SharePoint, Office to develop portals and mashups Gates offers musings on Office, services at ODC Office System Developer Conference 2008 preview What Visual Studio 2008 brings to client application development On migrating from VBA to VSTO Component works with Word files inside .NET applications VSTA: How lightweight can you get? Ten cool Visual Studio Orcas features, part 1 Office plug-ins possible with Visual Studio add-in

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

the specific types involved.

As for object models, the two write:

The other difference maker, of course, is Visual Studio Tools for Office, or VSTO -- though Whitechapel and Peltonen note that this tool is still evolving. The ideal toolset, the authors rationalize, would mix the functionality of VSTO, which offers better runtime performance, and shared add-ins, which are more flexible and backward compatible. And Visual Basic for Applications, which VSTO is set to replace, is still a viable option for developers who seek domain-specific solutions.

Despite the kinks and the learning curve, developing with Microsoft Office appears to be a sound decision for today's .NET professionals, Whitechapel and Peltonen conclude. Part of it relates to the platform's rich plumbing and Microsoft's commitment to improving the platform, and part of it stems from the vast base of end users that Office has. Those users demand custom functionality, whether it is controls within Office or applications outside Office, and now it is easier than ever to develop that functionality.

Rate this Tip To rate tips, you must be a member of SearchWinDevelopment.com. Register now to start rating these tips. Log in if you are already a member. DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.