1 / 23

Developing for the Microsoft Office System Jay Schmelzer Group Program Manager – Visual Studio

Developing for the Microsoft Office System Jay Schmelzer Group Program Manager – Visual Studio. Office Development? What is an OBA? Visual Studio 2008 & OBA Development Summary. Agenda. The past (and, as it happens, the present) VBA Add – ins (COM) Add – ins (Managed Code)

brooklyn
Télécharger la présentation

Developing for the Microsoft Office System Jay Schmelzer Group Program Manager – Visual Studio

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. Developing for the Microsoft Office System Jay Schmelzer Group Program Manager – Visual Studio

  2. Office Development? • What is an OBA? • Visual Studio 2008 & OBA Development • Summary Agenda

  3. The past (and, as it happens, the present) • VBA • Add – ins (COM) • Add – ins (Managed Code) • The recent history • .NET 3.0 • WCF • WPF • WF • VSTO • 2005 SE (VS 2005) • 3.0 in VS 2008 Pro and Above Development on the Client

  4. 2001 – Tahoe • Webstore • Digital Dashboard • SPS … STS… Confused? • 2003 – Now we’re talking • SQL. ASP.NET • Except, no workflow and profiling! • 2007 – THE platform • OBA Services • Workflow • Search • Office Servers Development on SharePoint

  5. Workflow state Document Properties and Metadata Calendars, Tasks Document libraries offline List data offline Bringing it Together Server Client Workflow state Document Properties and Metadata Calendars, Tasks List data updates Excel model publishing InfoPath form publishing Smart client customizations

  6. Lists • Export to Excel • Access synchronization • Item versioning • RSS Feeds & Alerts • Calendars • Link to outlook • Documents • Offline sync with outlook • Document management & status • Workflows • Workflow notification bar • Interactive forms display • Tasks • Offline sync with outlook • Export to Visio • Content Types • Document Property Panel • Data connection libraries • Browse from Excel • Central updates Native Client Integration(free when you build on SharePoint)

  7. RAD Visual designers for quick UI Extensibility • Simple Data binding for Word Content Controls • New VBA to VSTO Interoperability • Support for Custom SharePoint Workflow • More • Application-level add-ins for mostclient programs (both 2003 and 2007) • Document-level add-ins for Exceland Word 2007 and InfoPath • New ClickOnce deployment and improved security What is this VSTO?

  8. {DEMO}

  9. Extend the Office Fluent Ribbon Ribbon Designer Ribbon Controls Design Surface

  10. VSTO simplifies and speeds up task pane UI design process with visual designers and .NET hookup • Actions Pane: • Associated with a specific Word or Excel document • More robust, easier to program alternative to Office’s built-in “Smart Document” technology • Custom Task Pane: • The same general idea as Actions Pane, only on the application add-in level, not individual doc Create Custom Task & Actions Panes Custom Task Pane

  11. Toolbox 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 Word Content Controls

  12. Call VSTO from VBA Developers enable VBA via COM Interop Interop implemented at design time Developers can then call VSTO from VBA with IntelliSense after building the project

  13. Outlook Form Regions

  14. {DEMO}

  15. ClickOnce support • Complete end-to-end customization installation experience • Richer version-independent security model • Offline access via the ClickOnce Cache Deployment & Security

  16. Deployment & Security

  17. VSTO supports creation of SharePoint workflow to help manage business process and information flow • Reduces complexity and greatly speeds development of SharePoint workflow SharePoint Workflow Support

  18. {DEMO}

  19. VSeWSS • Free download for Visual Studio 2005 that allows you to create: • Team sites • Blank sites • Lists • … • VSeWSSv.next coming soon for Visual Studio 2008 Are There Other Tools?

  20. .NET 3.0 Provides more feature enhancements • WPF designer experience for improved UI • WCF service creation • WF capabilities • Also, LINQ supported in VS 2008 • Expression Blend as a designer tool • Projects integrate with VS 2008 What About Other Things?

  21. Office has evolved into a rich platform consisting of servers, applications, tools, and services. • You can use the Office platform to build OBAs. • OBAs include client-side and SharePoint customizations and integrate with LOB systems. • Look out for other tools (e.g. VSeWSSv.next) that will be compatible with VS 2008 Summary

  22. Email Me: • JaySch@Microsoft.com Questions?

More Related