Skip to main content

Understanding Office 2007 development

The Microsoft Office system evolved from a suite of personal productivity products into a comprehensive, multifaceted, and integrated system. Building on a solid foundation of familiar tools, the Microsoft Office system today includes applications, servers, services, and technologies designed to work together to solve a wide array of business problems. For example, the Microsoft Office system:

  • Simplifies content management for large enterprises
  • Enhances collaboration with coworkers, partners, and customers
  • Increases employee self-sufficiency

In addition, the 2007 release of Microsoft Office embraces open XML standards in order to enhance collaboration and interoperability across applications and organizations in ways never before possible.

Using the shared workspaces available in SharePoint Server 2007, information technology (IT) departments can collaborate over corporate boundaries as never before.

With the adoption of open standards-based technology, Microsoft Office replaces the proprietary binary formats used in previous versions with an open, fully documented, royalty-free format that is based on industry XML and ZIP standards.

The 2007 Office system also significantly improves productivity with the new Office Fluent interface, a new user interface that makes Microsoft Office applications easier to learn and easier to use.

Building robust, manageable, and intelligent solutions

With its integrated set of servers, services, and programs, the Microsoft Office system provides developers with the tools to create sophisticated solutions that are robust enough to meet the requirements of the most complex and demanding business environments.

      Microsoft Office interactive developer map
      The Microsoft Office Interactive Developer Map is a Windows Presentation Foundation (WPF) application that helps developers visualize the different programs, servers, services, and tools that will help them build solutions. It allows them to drill down to each product and technology and learn about new features, objects, Web services, namespaces, and schemas required to extend Microsoft Office and build custom Office Business Applications (OBAs).

      Developer roadmap for the 2007 Microsoft Office System

      Download this poster to view a developer roadmap for the 2007 system.

Powerful and extendable development tools

The Microsoft Office system contains a comprehensive set of tools and technologies that enable developers to implement and deploy custom solutions quickly and easily. The following paragraphs describe some of the many new technologies that are available in the 2007 Office system.

  • Office Fluent interface
    The Office Fluent interface is a new and extensible user interface that replaces menus, toolbars, and most of the task pane UI in Access 2007, Excel 2007, PowerPoint 2007, and Office Word 2007. The new UI is more efficient and is designed to help you discover all that Microsoft Office has to offer. Using XML and a conventional programming language, developers can create and extend Office Fluent components.

  • Application level add-ins
    Visual Studio Tools for Office includes application level add-in support for the most popular 2007 Office System applications including Outlook, Excel, Word, PowerPoint, InfoPath, and Visio. Add-ins can be safely and easily loaded, unloaded, and managed. The 2007 Office system offers the ability to create custom task panes that can be used to dock application-specific features and information to different areas of your screen.

  • Open XML Formats
    The 2007 Office system introduces new file formats for Word, Excel, and PowerPoint, called the Open XML Formats. The new Open XML Formats improve file and data management, data recovery, and interoperability with line-of-business systems. The new file formats are compatible with Microsoft Office XP, Microsoft Office 2003, and Microsoft Windows 2000 SP4 and later.

  • Document Inspector
    The Document Inspector allows you to examine documents for personal, hidden, or sensitive information. You can use built-in Document Inspector modules to remove unwanted information more easily.

  • Primary Interop Assemblies
    With the 2007 Microsoft Office system Primary Interop Assemblies (PIA) redistributable, developers can create applications using the Microsoft Visual Studio .NET development environment instead of developing and configuring connections using the COM-based object models.

  • Windows SharePoint Services 3.0
    Windows SharePoint Services is a component of Microsoft Windows Server that allows teams to create Web sites for information sharing and document collaboration. Windows SharePoint Services also serves as a platform for application development. The next version of Windows SharePoint Services takes full advantage of Microsoft ASP.NET 2.0 and the core Microsoft .NET 2.0 runtime. Components such as the Web Part Framework, MasterPages, and Web Virtualization are now provided by the .NET runtime rather than by Windows SharePoint Services.

The Microsoft Office System products and technologies

Explore the following table to discover more of the products and technologies available in the 2007 Microsoft Office system.

Product NameNew Features and Capabilities
Access 2007
  • Take advantage of the new Access 2007 Developer Extensions.
  • Data collection via e-mail has been improved.
  • Define import/export specifications.
  • AutoFormats, Navigation Pane, and Layout view have been improved.
  • Listen to events using managed code.
  • Store multiple value in single fields.
  • Integrate your Access data to SharePoint sites.
  • Take advantage of the single document interface (SDI).
  • Use built-in tracking applications.
Communications Server 2007
  • Deploy managed IM solutions that offer logging, archiving, file transfer, audio/video conferencing, and application sharing.
  • Take advantage of industry-standard protocols such as Session Initiation Protocol (SIP) and SIP for Instant Messaging and Presence. Leveraging Extensions (SIMPLE), and a rich set of application programming interfaces (APIs) to build value-added applications.
  • Use Real-time Communications (RTC) API 1.3 and Communications Server2007 to support role-based instant messaging.
  • Connect to Office Communicator through Communicator Web Access AJAX service and controls.
  • Build managed IM solutions using the Unified Communications Managed APIs.
  • Expand your application's language capabilities using Speech Platform Services.
Communicator 2007
  • Integrate with existing address books and corporate directories.
  • Share information about your availability with other contacts, and to view their availability.
  • Invoke other collaboration applications.
  • Enable rich presence in your application.
  • Better integration with other programs ensures that communications can occur in the context of the program being used, without having to switch to a different program for a different form of communication.
Excel 2007
  • Take advantage of increased row and column limits.
  • The conditional formatting UI has been revamped to make it faster and easier to use. New types of data visualization have been added.
  • Formula editing and performance has been improved to speed up calculations on modern hardware.
  • The charting engine has been improved for great looking charts in Excel and across Microsoft Office.
  • New formatting capabilities and improved styles to make creating professional-looking documents fast and easy.
  • Create PivotTables that are easier to read, more powerful, and great for working with SQL Server Analysis Services data.
  • A new class of functions have been created that return data directly from SQL Server Analysis Services
  • Connecting to external data is more straightforward and connection management capabilities have been added.
  • An all-new "Excel services" server technology enables sharing, controlling, and reuse of Excel workbooks on centrally managed servers.
  • New Office Open XML File Formats.
Microsoft Exchange Server 2007
  • Connect to Exchange using the Exchange Server 2007 Web Service API for Developers.
  • Take advantage of the new set of Web services that enable developers to interact with Exchange mailboxes and contents by using standard HTTP.
  • Configure Exchange client applications to access the Client Access server (CAS) through the Exchange Autodiscover Service.
  • Create Transport Agents using the new Transport APIs.
  • Restore storage groups and databases using the new Exchange Server 2007 Writer for the Windows Server 2003 Volume Shadowcopy Service.
Groove 2007 and Groove Server 2007
  • Develop solutions using the Groove Forms tool and the Groove InfoPath Forms tool.
  • Use Online Collaboration Templates For Groove-based Projects.
  • Extend collaboration solutions using Groove Web Services.
Infopath 2007
  • New Managed Code Object Model and Development Environments.
  • Build collaborative solutions that take advantage of the COM Add-in Support.
  • Take advantage of the new Form Template Converters.
  • Build solutions using the new Custom Data Importers.
  • View Control IDs in the Design Mode User Interface.
  • Use the new Data Connection Library Support.
  • Create solutions that retrieve data from XML Events.
  • Take advantage of the new Template Parts.
  • Build solutions using the InfoPath Editor Hosted as a Control.
Outlook 2007
  • Take advantage of more than 85 new objects added to the Outlook 2007 object model.
  • Customize both built-in and custom items in ways that were impossible in earlier versions of Outlook using Form Regions.
  • Use the Outlook Object Model Guard for improved security.
  • Use the new PropertyAccessor object to access Outlook object properties that are not available through the Outlook object model.
PowerPoint 2007
  • Create art using the new SmartArt graphic data model.
  • Add slides from a Slide Library to your presentation.
  • Extend the PowerPoint design template concept to Word, Excel, and even Outlook e-mail messages.
  • New Office Open XML File Formats.
Project 2007 and Microsoft Project Server 2007
  • Use the new Project Server Interface Web services to connect to Project Server business objects (that is, the logical entities).
  • Take advantage of more than 160 events, including both pre-event and post-event types.
  • Compile up-to-date portfolio-related information using industry-standard XML.
  • Integrate enterprise resources with existing Windows SharePoint Services.
  • Deploy code more easily using "trusted sources" lists shared with Microsoft Internet Explorer.
  • Load and synchronize resource information from Microsoft Active Directory services.
  • Project Professional 2007 and Project Standard 2007 include major improvements in creating reports from local Project files, using the Visual Reports feature with Visio 2007 and Excel 2003 or Excel 2007.
SharePoint Designer 2007
  • Create and customize Microsoft SharePoint Web sites.
  • Build workflow-enabled applications based on SharePoint technologies.
  • Maintain site performance with reports and managed permissions.
SharePoint Server 2007
  • Enable integration between enterprise portal and line-of-business (LOB) applications using the Business Data Catalog.
  • Provide control, organization, publishing, offline capabilities, draft item security, rights management, and records management using Document Management.
  • Enable site branding, creation of custom converters, building of multilingual sites, and building of content deployment solutions using Web Content Management.
  • Enable interaction with your spreadsheets (view, calculate, create snapshots, extract values) through a Web browser or programmatically through Excel Services.
  • Enable interaction with form templates designed with InfoPath 2007 through a Web browser through Office InfoPath Forms Services Capabilities.
  • Search has been improved to provide enhanced capabilities in portal sites, team sites, content management sites, and custom headless search applications.
  • Customize User Profiles and Audience Targeting to improve property management, imports, privacy and security, and My Page, plus the addition of memberships, shared context, and colleagues quick links.
  • Connect to SharePoint sites using single sign-on and alternate single sign-on providers.
Visio 2007
  • Link data to Shapes in a Visio Drawing.
  • Automatically generate diagrams from corporate data sources including databases and Web services.
  • Extract data from Visio diagrams into Excel, Word, Access, Microsoft SQL Server, or other tools for integration with business processes and systems.
  • Incorporate Visio into .NET-connected solutions using the Visio 2007 PIAs.
  • Embed the Visio Drawing Control in line-of-business applications built on Windows, .NET-connected technologies, and the Web.
  • Add glue connectors with AutoConnect.
Visual Studio 2005 Tools for the Office System
  • Build application-level add-ins for the most popular 2007 Office System applications including Outlook, Excel, Word, PowerPoint, InfoPath, and Visio.
  • Take advantage of the design-time and runtime support for key 2007 Office System features such as the Ribbon, Custom Task Panes, and Outlook forms regions.
  • Take advantage of the design-time support for InfoPath 2007 form templates.
  • Applications built with Office 2003 and VSTO 2005 with continue running with the 2007 Office system.
  • Take advantage of the expanded application-level add-in support for these Office 2003 Standard and Professional applications: Word, Excel, Outlook, PowerPoint and Visio.
Word 2007
  • Take advantage of content controls, a predefined set of blocks of content that you can position anywhere in a document.
  • Create a link between a document and a custom XML file using XML Mapping.
  • Create custom building blocks to facilitate the quick creation of professional-looking Word documents.
  • New Office Open XML File Formats.