1 / 44

Visual Studio 2008 and Office Development

Olaf Feldkamp Developer Platform Advisor Microsoft Switzerland blogs.msdn.com/ swiss_dpe_team. Visual Studio 2008 and Office Development. Agenda. Introduction Visual Studio 2008 Key Features Additional Guidance and Tools Conclusion. 2007 Office Client Platform Investments.

garrick
Download Presentation

Visual Studio 2008 and Office Development

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. Olaf Feldkamp Developer Platform Advisor Microsoft Switzerland blogs.msdn.com/swiss_dpe_team Visual Studio 2008 and Office Development

  2. Agenda • Introduction • Visual Studio 2008 Key Features • Additional Guidanceand Tools • Conclusion

  3. 2007 Office Client Platform Investments • Custom Fluent Ribbons • Custom Task Panes • Core • Word: Content Controls • Excel: BI functions • Outlook: Unifiedobject model, FormRegions • InfoPath: .NET Object Model • Open XML Formats • ImprovedmanagedAdd-in support Office Fluent Ribbon Core TaskPanes Managed Add-in(s) Storage Web Services

  4. Office Business Applications (OBA) OfficeBusiness Applications LOB Apps

  5. Visual Studio 2008 Investments • Visual Studio 2008 enables developers to • Build scalable Office Business Applications • Leverage key Office UI features, support workflow and easier deployment • Office development is part of Visual Studio 2008 Professional and higher editions • Compatibility and maintainability assurances Design Time .NETFW 2.0/3.0/3.5 Outlook, Word, Excel, .. COM API PIAs Visual Studio Toolsfor Office (VSTO)3.0 Runtime Your.NETAdd-in Run- time

  6. Past VSTO Releases

  7. Office Development withVS 2008

  8. Agenda • Introduction • Visual Studio 2008 Key Features • Additional Guidanceand Tools • Conclusion

  9. VSTO ↔ VBA Interop

  10. Office Development: Earlierand Today from 2003 Visual Studio Tools for Office(VSTO) VBA/COM add-in (1995 - 2001) .NET (from 2002)“shared add-in” Marketgap Office Business Applications Complexity VBA(as applied), COM add-in, .NET“sharedadd-in” Advanced app-level add-ins Complex document add-ins Simple app-level add-ins VBA (still) Simple document add-ins VBA(asintended) Macro modify Macro record/replay (InfoPath 2007)

  11. VSTO ↔ VBA Interop • For Excel 2007 and Word 2007 documentcustomizations • VSTO  VBA Interop • i = Me.Application.Run("mySpecialAddVBA", 5, 6) • VBA  VSTO Interop: New properties enable code to be called from VBA Intellisense for VBA-callable components

  12. VSTO ↔ VBA Interop demo Excel DocumentCustomization

  13. Task Paneand Actions Pane

  14. Task Pane and Actions Pane • Visual Studio 2008 simplifies and speeds up their development process • Actions Pane • Document-specific • Custom Task Pane • Application-specific • You can use a WPF UCLibrary (insteadofWinForms UC)due to WinForms↔ WPF Interop: Link

  15. Whattochoose? • a

  16. Office FluentRibbon Designer

  17. Office Fluent Ribbon Development • Office has built-in support for XML-based customization model • VSTO 2005 SE • Simplified hookup from .NET via pre-generated classes and sample XML • Visual Studio 2008 • Adds full-blown visual designer, “Export to XML” option

  18. Remark • Most demosshown in thispresentationarepartofthe MSDN Hands-on Lab OBA • Download manualandfileshere on ourteamblog

  19. Task Pane, Ribbon Designer demo Excel Application Add-in

  20. Outlook 2007 Form Regions

  21. Outlook 2007 Form Regions

  22. Outlook 2007 Form Regions (2) • Form Regions Designer • Design a User Control in Visual Studio • Speeds up Form Region development • Run and debug your Form Region from Visual Studio • No need to manually handle manifest XML, OFS files, Reg. entries

  23. Outlook 2007 Form Regions demo Outlook 2007 Add-in

  24. Word 2007 Content Controls

  25. Word 2007 Content Controls • Information Worker • Friendly end user exposure of structured content • Ensures that your structure stays in the document • Developer • Evolution of custom defined XML schemas • No XML schema required to apply structure • Controls can be mapped to XML data • Program against the controls

  26. Word 2007 Content Controls demo Word 2007 Document Customization

  27. SharePoint Workflow Development

  28. SharePoint Workflow Development • Creating a workflow for MOSS 2007 with Visual Studio 2005 is painstaking • Much time is spent troubleshooting the development environment - not the customization itself • The number of steps involved in a simple debugging session is excessive

  29. Visual Studio 2005: 15 Steps • New workflow project in Visual Studio 2005 • Author the feature definition file • Add GUID, title, description, manifest location • Author workflow template definition file • Add GUID, name, description • Compile the workflow files into a .NET assembly • Sign the assembly • Add key file • Design the actual workflow, add code etc. (the “real” developer task) • Install assembly into the Global Assembly Cache • Extract public key token • Add key token to workflow template definition file • Deploy feature definition file to SharePoint file system • Deploy workflow definition file to SharePoint file system • Reset Internet Information Services • Press F5 • Attach to WPW3.exe process • Associate workflow with document library

  30. Visual Studio 2008: 3 Steps • New SharePoint WF project in Visual Studio 2008 • Design the workflow, add code, WF Task and Forms, .. • Press F5 • VS 2008 makes it easy to create, customize, and debug a SharePoint WF

  31. ClickOnceDeployment

  32. ClickOnce Deployment • ClickOnce supports Office add-ins and document customizations! • Low-impact deployment mechanism introduced in .NET FW 2.0 for Windows Forms applications • No admin rights used • Application update without user intervention • Offline access via ClickOnce cache • Application installed per user • Permission elevation prompting with Authenticode • Uninstall using Programs and Features • Supports both web deployments and network shares

  33. .NET 3.5 ClickOnce Enhancements • Firefox support • Application no longer tied to a publish location on signing • Distributed apps maintain the author’s branding • Authenticode certificates now renewable across updates • Works across authenticated proxies • Note: These enhancements are also included in .NET 2.0 SP1 and .NET 3.0 SP1

  34. ClickOnce for Office Applications • Prerequisites (requireadminrights) • .NET FW 3.5 • VSTO 3.0 Runtime • Office 2007 Primary InteropAssemblies • ClickOnce • Deploysadd-in/customizationtoClickOnce Cache • Creates Office and VSTO relatedregistrysettings (HKEY_CRRENT_USER) • Addsentryto „Programs and Features“

  35. ClickOnce Deployment demo Deploying an Outlook 2007 Add-in

  36. Agenda • Introduction • Visual Studio 2008 Key Features • Additional Guidanceand Tools • Conclusion

  37. Outlook+Services Blueprint Getdetails on Channel9

  38. VSTO Power Tools 1.0 • A set of developer tools designed to complement Visual Studio Tools for Office • Download on MSDN

  39. VSTO Power Tools 1.0

  40. VSTO Power Tools 1.0 demo VSTO Developer Cleanup VSTO Troubleshooter Office Custom UI Manager

  41. Agenda • Introduction • Visual Studio 2008 Key Features • Additional Guidanceand Tools • Conclusion

  42. Key Takeaways A unified solutions platform for building Office Business Applicationsthat make line-of-business systems andenterprise data accessibleand relevantto users Provides premiere developer toolset for developing Office Business Applications and scalable enterprise grade solutions based on the Microsoft Office system

  43. © 2008 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.

  44. Resources • Microsoft Office Interactive Developer Map (Version 2)

More Related