Visual Studio 2005 Tools For Office For Mere Mortals

VSTO for Mere MortalsTM is for VBA developers who are interested in migrating their skills to the next generation of Office development. Readers will benefit from a straightforward, practical introduction to writing managed code applications for Word 2003, Excel 2003, and Outlook 2003. Readers will also learn how to create add-ins for the most popular applications for Office 2003 and the 2007 Microsoft Office system using VSTO 2005 SE. The expert authors provide a wealth of code samples that show off popular features of VSTO, such as smart tags and the actions pane. Sample code also shows you how to customize the new UI features of the 2007 Microsoft Office system, including the ribbon, custom task pane, and Outlook forms region. VBA developers will walk away with A greater understanding of managed code and the Visual Studio integrated development environment (IDE) Multiple demonstrations on how to create document-level customizations for Word 2003 and Excel 2003, using view controls, data binding, and the actions pane A comprehensive overview of add-in development for Outlook 2003 Useful information on securing and deploying solutions created with VSTO and VSTO 2005 SE A thorough explanation on how to migrate VBA solutions to Visual Basic 2005 and VSTO Numerous details on customizing the ribbon, custom task pane, and Outlook form regions by developing VSTO 2005 SE add-ins for the 2007 Microsoft Office system

Microsoft® Visual Studio 2008 Unleashed is an end-to-end, deep dive into the Visual Studio development environment. It’s meant to provide you guidance on how you can squeeze the ultimate productivity out of the many features built into the .NET development tools. Understanding how to use your tools will make you a better developer. This book was written with that premise as its focus. The authors have folded in real-world development experience alongside detailed information about the IDE. The result is practical, easy-to-employ information that will make you a more productive and complete developer. This book also helps to ease your transition from other development environments and former versions of Visual Studio. Finally, this book provides an entire section dedicated to Visual Studio Team System. It will help you understand how the Team Architect, Team Developer, Team Database Developer, and Team Tester work with the Team Foundation Server to increase team collaboration, visibility, and productivity. Microsoft® Visual Studio 2008 Unleashed provides straight, to-the-point answers to common developer questions about the IDE. Detailed Information on... What’s new in Visual Studio 2008 Working with solutions, projects, editors, and designers Writing ASP.NET applications Writing and consuming Web Services using Windows Communication Foundation (WCF) Writing Windows Forms and Windows Presentation Foundation (WPF) applications Creating and hosting workflow-based applications using Windows Workflow Foundation (WF) Working with data and databases Refactoring code Debugging code Automating the IDE Writing macros, add-ins, and wizards Using team collaboration and the Visual Studio Team System products Managing source code changes Tracking projects with Team Foundation Server and work items Modeling applications Performing unit, web, and load testing Working with Team Foundation Build

Explore the features, the installation, and the configuration of these seven new servers and gain a conceptual understanding of how your users will be working with them. Forms Server 2007 Groove Server 2007 Communications Server 2007 PerformancePoint Server 2007 Project Portfolio Server 2007 Project Server 2007 SharePoint® Server 2007 for Search Along with the release of Windows Vista and the revamped suite of Office 2007 products, Microsoft has released a line-up of new servers. Exchange Server 2007 and SharePoint® Server 2007 are two of the major players, but there are also seven additional Office 2007 Servers of which you may not be aware that can add productivity to your environment in a variety of ways. Each of the seven servers is unique and requires distinct assessment to determine if your company can benefit from any given server. This book provides you with the knowledge you need to determine the use of each server, the prerequisites and procedures of server installation, the post-installation configuration options so you can set it and forget it, and finally, a look at the client-side applications that interact with the new servers. Detailed information on how to… Install each of the seven Office 2007 Servers, including both standalone and server farm installation. Handle post-installation configuration options for each of the seven Office 2007 Servers. Create InfoPath forms to post to your InfoPath Forms Server. Work with the Groove client once your Groove Servers are in place. Communicate more efficiently within your company using a Communications Server and the new Communicator 2007 client. Handle larger projects through Project Professional 2007 with your new Project Server and Project Portfolio Server. Understand Business Intelligence (BI) in order to manage your company’s future through PerformancePoint Server. Improve your ability to search for content through your SharePoint Server for Search. J. Peter Bruzzese is an independent consultant and trainer for a variety of clients including CBT Nuggets, New Horizons, and ONLC.com. Over the past ten years Peter has worked for/with Goldman Sachs, CommVault Systems, and Microsoft, to name a few. He focuses on corporate training and has had the privilege of working with some of the best trainers in the business of computer education. In the past he specialized in Active Directory and Exchange instruction, as well as certification training. Peter is a contributor to Redmond Magazine, WindowsITPro magazine, and several tech sites, and a speaker for the MCP TechMentor Conferences. Ronald Barrett is the director of information technology for an accounting and financial services firm, while also serving as chairman for the Technology Executive Committee for CPAmerica, a national CPA network, consisting of 15,000+ professionals.

Professional Visual Studio 2005 Tools for Office satisfies the need to write enterprise software based on Office by delivering practical solutions for those seeking to port existing functionality to VSTO. The book focuses on code and implementation, not theory, with code examples presented in both VB and C#. The book is especially written for enterprise developers - VBA or COM Interop savvy - who need to leverage the power and productivity of VSTO today. .NET developers seeking to explore VSTO as a potential solution will also find ample material that suits their needs. This book covers VSTO 2005 in detail. The approach focuses on the major components that form the suite with the exception that InfoPath is not covered. All other components benefit from an exploration of the key objects that are most likely to be used in common programming scenarios. This book is organized into chapters that present the building blocks of VSTO first. Microsoft Excel and its Range objects form the cornerstone of range manipulation across the VSTO suite. For that reason, the first few chapters explain these basic concepts. Subsequent chapters use these building blocks as a starting point so it is important to be familiar with these concepts before skipping to the back of the book. Once you gain a complete understanding of the Excel Range object in Chapters 2 and 3, you can apply that knowledge to the remaining chapters. In fact, Microsoft Word, Charts and Pivot Table manipulation are all based on the Excel Range object. (VSTO contains a potent charting engine second to none. And this book explores every facet of charting.) The obvious benefit of this clever architecture is that it significantly reduces the learning curve for those who wish to adopt this relatively new technology. And this book is designed to show you how to exploit this architecture.

This book is written by a developer and architect with 9 years’ experience building Information Worker solutions, including custom workflow engines and third-party workflow products. The author challenges readers to view the Office System and workflow in a new light, walking readers through the process of building a solid, useable workflow solution. Unlike quick references that scratch the surface of new technology, this book benefits the serious Information Worker developer - a growing group in IT - who is interested in learning the inner workings of workflow and Office 12.

Visual Studio Tools for Office is both the first and the definitive book on VSTO 2005 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Visual Studio .NET and the .NET Framework to put code behind Excel 2003, Word 2003, Outlook 2003, and InfoPath 2003. VSTO provides functionality never before available to the Office developer: data binding and data/view separation, design-time views of Excel and Word documents inside Visual Studio, rich support for Windows Forms controls in a document, the ability to create custom Office task panes, server-side programming support against Office, and much more. Carter and Lippert cover their subject matter with deft insight into the needs of .NET developers learning VSTO. This book Explains the architecture of Microsoft Office programming and introduces the object models Teaches the three basic patterns of Office solutions: Office automation executables, Office add-ins, and code behind a document Explores the ways of customizing Excel, Word, Outlook, and InfoPath, and plumbs the depths of programming with their events and object models Introduces the VSTO programming model Teaches how to use Windows Forms in VSTO and how to work with the Actions Pane Delves into VSTO data programming and server data scenarios Explores .NET code security and VSTO deployment