1 / 31

Office as a Development Platform

Office as a Development Platform. Tim Heuer timheuer@microsoft.com http://timheuer.com/ 602-405-4567. That was then…. An Office Client Today…. An Office Client Today…. An Office Client Today….

cassara
Download Presentation

Office as a Development Platform

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Office as a Development Platform Tim Heuer timheuer@microsoft.com http://timheuer.com/ 602-405-4567

  2. That was then…

  3. An Office Client Today…

  4. An Office Client Today…

  5. An Office Client Today…

  6. A unified solutions platform for building Office Business Applicationsthat make line-of-business systems, enterprisedata and workflows accessible and relevant to users. Fully integrated Visual Studio Tools for Office technologies enable developers to build Office Business Applications and scalable enterprise grade solutions based on Microsoft Office.

  7. Office Business Applications (OBA) • New Breed of Applications • Use the Microsoft Office System to find and surface Line of Business Information • Composition point for the S+S vision • Pull through the entire stack • More info at http://www.microsoft.com/office/oba and http://msdn.microsoft.com/oba

  8. Visual Studio Tools for Office (VSTO) • ServerDocument – manipulate documents without automating Office • Word content control support • Ribbon customization • Word content controls • Outlook form region customization • Document-level solutions • Word, Excel, InfoPath 2003 onwards • Managed controls on the doc surface • Doc-level Actions Pane • Application-level Add-ins • Appdomain isolation • Office 2003 & 2007 Office system apps • App-level custom task pane • Highly streamlined developer experience • New designers for ribbon and Outlook form region • VBA => VSTO interoperability • ClickOnce deployment and security • Support for Workflow and Microsoft SharePoint

  9. Developer Benefits RAD design experiencefor building Office-based apps Utilize key2007 Office systemUI features Streamlined tasks& processes + = Build OBAs that leverage enterprise resources

  10. Fluent UI and customization • Outlook Customization • Word Content Controls • Task Pane integration

  11. UI Customization in Visual Studio • Increased visual designer capability • Extended support for customizable task/action panes • Extended Outlook Form Region capabilities • Ribbon UI designer tools

  12. Example: Office Fluent Ribbon Extension Tab Control Group Ribbon Ribbon Designer Ribbon Controls Design Surface

  13. demo Ribbon UI Customization

  14. Outlook Form Regions • Visual Studio simplifies and speeds up Outlook form region design and configuration process with a visual designer and a wizard • Achieve maximum form region design flexibility with VS visual designer • Configure your form region with a simple, intuitive wizard • Run and Debug your form region right from VS (F5) • No need to manually handle manifest XML, OFS files, registry entries, etc. • Option to import Outlook-created OFS file • Implement a custom form region with an add-in

  15. Outlook Form Regions

  16. demo Outlook Form Regions

  17. Word Content Controls • New experience for developing structured documents in Word 2007 • New UI for developers to access Word Content Controls • Programmable through Word Object Model • Support for XML Mapping Toolbox Controls

  18. Custom Task Panes • Visual Studio 2008 provides app-level custom task panes • Create custom task panes with an add-in • Add-in support & task pane support for • Project, Excel, InfoPath, Outlook, PowerPoint, Word • Custom task panes appear in the main application window or (Outlook) inspectors • Populate custom task pane with UserControls • Populate user controls with Winform controls

  19. demo Word Content Controlsand Task Panes

  20. Much more… • Smart Tags • SharePoint Workflow/WebParts • Office Communicator/Presence Integrations • Office Open XML • Excel Server • InfoPath

  21. For More Information • Cheat Sheets • MsoId - http://tinyurl.com/24zd8u • OfficeImageId - http://tinyurl.com/29dljb • OBA Central • www.obacentral.com • OBA for Architects • http://msdn2.microsoft.com/en-us/architecture/aa699381.aspx • OBA Dev Center • http://msdn2.microsoft.com/en-us/office/aa905528.aspx

  22. appendix

  23. SharePoint Workflow Support • Visual Studio 2008 supports creation of SharePoint workflow to help manage business process and information flow • Reduces complexity and greatly speeds development of SharePoint workflow

  24. VSTO Design-time Stack Microsoft Office Excel®, and Word Excel, InfoPath, Outlook®, PowerPoint®, Visio, Word, (Access, Project) Microsoft SharePoint® Server 2007 Visual Studio Excel, Outlook, PowerPoint, Word, (Access) Excel, Outlook, PowerPoint, Word, (Access) Office IDE Hosting Outlook Workflow Document Solutions Add-ins Ribbon Ribbon XML Form Regions Project Templates Item Wizards Visual Studio

  25. VSTO Runtime Stack Microsoft Office Client Host Doc-Level Solution App-Level Add-in VSTO Runtime Doc Task Pane Host Item Controls Windows Forms Controls Custom Ribbon Custom Task Pane Custom Form Region Common VSTO/A Runtime AppDomain Management Security Enforcement Deployment and Updating .NET CLR Managed Add-in Framework (MAF) ClickOnce

  26. Deployment & Security • ClickOnce support • Complete end-to-end customization installation experience • Install from CD, removable drive storage, the web or network shares. • Richer version-independent security model • No longer reliant on CASPOL • Offline access via the ClickOnce Cache • Supports both web deployments and network shares

  27. ClickOnce • Low-impact deployment mechanism • Self-contained • Solutions installed per user • Prerequisites are installed if the user is an admin • Supports solution update / rollback without user intervention • Offline availability of solution

  28. Security • Customization • No longer use ‘CASPOL’ • Version-independent ClickOnce model • Works with future versions of .NET, VSTO Runtime & Office • Security evaluated on the deployment manifest • Check if the Deployment Manifest URL is in the IE Restricted sites • Evaluate certificate used to sign the deployment manifest • Consult the inclusion list • Security evaluated on installs & updates • Documents • Office 2007 Trusted Folder List • Customization still needs to be trusted

  29. Custom Task Panes: MDI vs. SDI • New custom task pane model not tied to the document • Its behavior is dependent upon the distinction between MDI and SDI

  30. VBA & Managed Code Interoperability • VBA can now call managed code with IntelliSense • This feature works for Word and Excel in Office 2007 • Preserves the investment in VBA • Enables incremental extension of VBA solutions using VB or C# • Brings the power of .NET to your VBA solutions

  31. Call Managed Code from VBA • Developers enable VBA via COM Interop • Interop implemented at design time • Developers can then call managed code from VBA with IntelliSense after building the project

More Related