230 likes | 449 Vues
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)
E N D
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) • 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
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
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
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)
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?
Extend the Office Fluent Ribbon Ribbon Designer Ribbon Controls Design Surface
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
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
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
ClickOnce support • Complete end-to-end customization installation experience • Richer version-independent security model • Offline access via the ClickOnce Cache Deployment & Security
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
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?
.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?
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
Email Me: • JaySch@Microsoft.com Questions?