Developer Productivity Improvements with Visual Studio 2008 and Office Business Applications

1. Developer Productivity Improvements withVisual Studio 2008 andOffice Business Applications

2. What Will We cover? • Overview of Visual Studio Tools for Office (VSTO) • Architecture • New built in add-ins

3. Helpful Experience • Developing Visual Studio Applications • Microsoft Office and Office Business Applications Level 300

4. Agenda • Office As A Developer Platform • The “Results Gap” with LOB Apps • Office Business Applications • VSTO Overview • SharePoint WorkFlow Tools • Ribbon Development • Custom Task Pane • ClickOnce Deployment

5. Office as a Developer Platform • Familiar user interface • 500+ million users worldwide • Office Open XML file formats • Microsoft Office SharePoint Server 2007 • Enabling collaboration • Portals • Enterprise search • Enterprise content management • Business process support • BI delivery platform

6. Agenda • Office As A Developer Platform • The “Results Gap” with LOB Apps • Office Business Applications • VSTO Overview • SharePoint WorkFlow Tools • Ribbon Development • Custom Task Pane • ClickOnce Deployment

7. The “Results Gap” LOB Apps

8. Office Business Applications LOB Apps

9. Agenda • Office As A Developer Platform • The “Results Gap” with LOB Apps • Office Business Applications • VSTO Overview • SharePoint WorkFlow Tools • Ribbon Development • Custom Task Pane • ClickOnce Deployment

10. Office Business Applications Word Excel Outlook InfoPath Estimate custom design Unstructured Estimate custom design Unstructured Office SharePoint Server Get specs from customer Validate specs with Tech Sales Assemble proposed response Approve proposed response Cost out the solution Decide discount strategy “Classic” Enterprise Applications Create Lead Create Oppt’y Create Quote Complete Sale Create Invoice Qualified? Closed? Retire Lead Structured

12. Visual Studio Tools for Office VSTO 2008 • New designers: ribbon, custom task pane, Outlook form region • App-level add-ins for most client programs • ClickOnce deployment and security • VBA/VSTO interoperability • Workflow & Microsoft SharePoint support • VSTO integral part of Visual Studio 2008 Professional VSTO 2005 & VSTO 2005 SE • Custom ActionsPane • Host Controls on doc surface • Cached Data in the document • Server-side data processing • App-level add-ins for Outlook VSTO 2003 • Document-level code behind • Brings Microsoft Office into the managed world • Strict security model

13. Office Applications • Visual Studio 2008 Professional includes Visual Studio Tools for Office • Visual designers for Ribbon, Task & Action pane, SharePoint Workflow • Integrated Workflow & Microsoft SharePoint Support • Data binding in Word Content Controls • Application-level add-ins for most client programs (both 2003 & 2007) • Document-level add-ins for Excel & Word 2007 • Improved deployment and security using ClickOnce

14. Agenda • Office As A Developer Platform • The “Results Gap” with LOB Apps • Office Business Applications • VSTO Overview • SharePoint WorkFlow Tools • Custom Task Pane • Ribbon Development • ClickOnce Deployment

15. SharePoint Workflow Tools • What is a workflow? • A reliable repeatable pattern of activity enabled by a systematic organization of resources and information flows • E.g. Document approval process • Workflow Foundation (WF) integrated • Programming model, engine and tools to build workflow enabled applications • Consists of a Microsoft .NET Framework v3.0 (formerly WinFX)

16. SharePoint Workflow Tools • VSTO vs. SharePoint Designer • Limited reusability • Develop, deploy, and debug SharePoint workflows • “Simple F5 Experience“ • Focus on your business logic right away

17. Creating A SharePoint WorkFlow

18. Custom Task Pane • Adds custom functionality • Dynamically set properties • Show/Hide, dock position • Responds to event handlers • On hide, on show, on data bind • To create a Custom Task Pane, • Create UserControl for UI and functionality • Add UserControl to CustomTaskPaneCollection

19. Building a custom Task Pane

20. Ribbon Development • Office has built-in support for XML-based customization model • VSTO 2005 SE support: • Simplifies hookup from .NET via • pre-generated classes and sample XML • VSTO 2008 support: • Adds full-blown visual designer support • “Export to XML” option • A more robust programming layer

21. Building a custom Ribbon

22. ClickOnce Deployment • Two competing goals in application development • Interactive, stateful, rich client application • Thin client application model • ClickOnce deployment overcomes: • Difficulties in updating applications • Impact to the user’s computer • Security permissions

23. ClickOnce Deployment • Three ways to publish a ClickOnce application • From a Web page, network share, media • ClickOnce applications are self-updating • ClickOnce applications are isolated and self-contained. • Cannot break existing applications

24. ClickOnce Deployment

25. Setting Up ClickOnce Deployment

26. Session Summary • Office as a develop platform • Office business applications bridges the “Results Gap” • Visual Studio Tools for Office • SharePoint Workflow • Custom Task Pane • Ribbon Development • ClickOnce Deployment

27. For More Information • Office Developer Center • http://msdn2.microsoft.com/en-us/office/aa905533.aspx • VSTO Blog • http://blogs.msdn.com/vsto • MSDN Web site • msdn.microsoft.com