Get to grips with Programming Office 2007 using Visual Studio Tools for Office

Experienced author Ty Anderson cuts to the chase in explaining how professional Microsoft Office 2007 solution developers get the job done. Ty is a professional Microsoft application developer working each and every day with the Visual Studio Tools for Office (VSTO) technology, and his real–world experience will teach you exactly what you need to know to excel in your professional development career. Pro Office 2007 Development with VSTO takes you far beyond traditional Visual Basic for Applications (VBA) programming, showing you how to transform Microsoft Office 2007 into a complete enterprise application development platform. By the end of the book, you will be creating your own powerful, customized Office business applications (OBAs), using the techniques Ty has taught you throughout. The author demonstrates how to leverage all aspects of the Microsoft Office application platform (covering Word, Excel, Outlook, PowerPoint, Visio, and InfoPath) so you can create OBAs that increase information worker productivity, unlock business data stored in documents, reduce end–user training costs, increase developer productivity, and reduce IT operations costs. This book takes you beyond the basics of VSTO with expert topics such as automation with the Office application object models and includes detailed examples throughout.

This book focuses on innovative ways to create customized Word documents and templates. It contains an in-depth introduction to VBA (Visual Basic for Applications), which is the embedded programming language in the Microsoft Office 2007. VBA provides a complete integrated development environment (IDE) that allows for document automation, the process of using an automated template for creating documents. The book also includes coverage of the new features of Word 2007 including Content Controls, programming the Ribbon, and more.

Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Microsoft Visual Studio 2008 and the .NET Framework to program against Microsoft Office 2007. This book delivers in one place all the information you need to succeed using VSTO to program against Word 2007, Excel 2007, and Outlook 2007, and provides the necessary background to customize Visio 2007, Publisher 2007, and PowerPoint 2007. It introduces the Office 2007 object models, covers the most commonly used objects in those object models, and will help you avoid the pitfalls caused by the COM origins of the Office object models. Developers who wish to program against Office 2003 should consult Carter and Lippert’s previous book, Visual Studio Tools for Office. In VSTO 2008, you can build add-ins for all the major Office 2007 applications, build application-level custom task panes, customize the new Office Ribbon, modify Outlook’s user interface using Form Regions, and easily deploy everything you build using ClickOnce. Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO, based on the deep knowledge that comes from the authors’ unique perspective of living and breathing VSTO for the past six years. This book Explains the architecture of Microsoft Office programming and introduces the object models Covers the main ways Office applications are customized and extended Explores the ways of customizing Excel, Word, and Outlook, and plumbs the depths of programming with their events and object models Introduces the VSTO programming model Teaches how to use Windows Forms and WPF in VSTO and how to work with the Document Actions Pane and application-level task panes Delves into VSTO data programming and server data scenarios Teaches ClickOnce VSTO deployment This is the one book you need to succeed in programming against Office 2007. C# and Visual Basic .NET Code samples for download can be found here: http://www.informit.com/store/product.aspx?isbn=0321533216

As the most radical change to the Office interface in its history, the Ribbon replaces the traditional menu bar and toolbars and requires a new set of skills for customizing Instructions and examples demonstrate how to customize the Ribbon using VBA, XML, Access, Excel, and Word Covers the relevant aspects of security, such as trust centers and digital certificates Packed with real-world code examples that readers can immediately apply Features helpful references

Written by one of the most popular and knowledgeable Microsoft Outlook MVPs, this book fills a void in the market for a professional-level Outlook programming book Explains how to use the many new features of Outlook 2007's object model and offers honest advice from the author on how to deal with common shortcomings and pitfalls of Outlook Addresses common workarounds for Outlook programming bugs and how to interface with Word, Excel, SharePoint, and Access Discusses the new Object Model, Outlook forms, COM add-ins, security, and more

This is a professionals’ guide to understanding and implementing the key principles and techniques of programming Microsoft Office Excel 2007. Automating complex spreadsheets, streamlining time-intensive work processes, gaining the competitive edge, and making more money for your businesses: these are all reasons to take Excel to the next level. This book teaches how to do just that, with the author using his own real-life experience to develop your understanding to this professional level. The text teaches the most efficient way to create complex and feature rich VBA code, exposing all the new features and capabilities that make Excel 2007 so exciting.