• Features end-to-end scenarios for using Office 2007 and SharePoint 2007, from generating Office documents programmatically to integrating document-based workflows with line of business applications or Web sites
• Takes an in-depth look at integrating the information worker products from Microsoft into broader solutions for the enterprise
• Some of the topics covered include building a workflow solution with Office and SharePoint 2007; programming SharePoint lists, items, and libraries; building Business Intelligence (BI) including Excel BI, Excel and Access Reporting, and SharePoint integration; using Web Content Management with SharePoint; and more

From generating Office documents programmatically to integrating document-based workflows with Line of Business applications or web sites, you''ll see how to get the most out of your SharePoint environment. In order to do this, you''ll examine how to integrate Microsoft''s information worker products such as SQL Server 2005 and Office 2007 into broader solutions for the enterprise.

Throughout the book, the following key areas are covered in-depth: portal services in SharePoint, search, document and content management, and workflow integration. The expert authors also provide you with scenarios to build out these applications and leverage the platform services along with custom code to create new solutions. In addition, key examples demonstrate how SharePoint and Office work together to offer powerful capabilities and how Office can be an integral part of the development platform.

What you will learn from this book

• All about what''s new for developers in SharePoint and Office 2007

• Techniques for programming SharePoint lists and libraries

• Tips for building business intelligence applications with SharePoint and Office

• Ways to take advantage of XML, web services, and extensibility in Office 2007

• Methods for creating custom workflows for Windows SharePoint Services and Microsoft Office SharePoint Server

• How to manage web content in Microsoft Office SharePoint Server

Who this book is for

This book is for experienced .NET, SharePoint 2003, Excel, and Access VBA developers who are expanding and upgrading their development skills.

Randy Holloway works as a technical advisor for Microsoft's enterprise software customers in St. Louis. Prior to joining Microsoft, Randy served as an IT director focused on software engineering and ERP systems support in addition to his writing and speaking engagements for a variety of industry publications and conferences. Randy holds a B.S. from Mississippi State University. He lives in St. Louis, Missouri, with his wife and two children. He also writes a weblog focused on technology and industry trends, located at http://randyh.wordpress.com.

Andrej Kyselica advises Microsoft's enterprise healthcare customers on technology strategy and architecture. Before joining Microsoft, Andrej worked in consulting for 9 years as a practice director and CTO focusing on .NET and portal solutions. Outside of work, Andrej enjoys cycling, running, and spending time outdoors with his wife and five children.

Steve Caravajal is a principal architect with the Microsoft Corporation. He has been architecting, deploying, and customizing SharePoint solutions since v1. Steve has over 25 years' experience in technology and product development. He holds a B.S. in chemistry and mathematics and a doctoral degree in chemistry and computer science. Steve is a software developer at heart, having written and managed the development of numerous enterprise software applications in .NET, Java, and C++. He currently lives in Cincinnati with his wife Rosemary. In his spare time he enjoys playing foosball, ping-pong, and blackjack.