Book Image

VSTO 3.0 for Office 2007 Programming

By : Vivek Thangaswamy
Book Image

VSTO 3.0 for Office 2007 Programming

By: Vivek Thangaswamy

Overview of this book

With the arrival of Visual Studio Tools for Office 3.0 (VSTO), developers can now program Microsoft Office from the .NET framework. There are huge books in the market that give loads of unnecessary information but are of no real help to brand-new Office developers. Wouldn't it be great to have a precise book that simply covers the basics and introduces programming Office 2007 with VSTO using the latest version of Visual Studio? This is that book. VSTO 3.0 for Office 2007 Programming shows you how to write Office 2007 applications with Visual Studio Tools for Office 3.0. Learn how to automate tasks in InfoPath, Word, Excel, Outlook, PowerPoint, Visio, and Project 2007 with greater programming power and flexibility than was available from the VBA language. With this book and the mastery of VSTO you will learn, Office will no longer be an application to you; it will be a platform for developing custom applications.VSTO 3 is the most recent version of VSTO, making use of Visual Studio 2008, and working with Office 2007. This book shows how VSTO puts Office automation into the hands of developers, allowing them to use the power of the .NET framework to automate Office applications thus increasing the speed of the applications, their security, and the opportunity to use other parts of the .NET Framework such as its data handling capabilities. This book builds a solid programming foundation in VSTO for brand-new Office developers. You will leave behind the world of VBA programming and take your first steps into the powerful and exciting world of using C# to create Office 2007 applications. Packed with examples and covering all the main Office applications, this book will have you creating fully featured Office extensions before you know it.
Table of Contents (11 chapters)
VSTO 3.0 for Office 2007 Programming
Credits
About the Author
About the Reviewers
Preface

Creating Office applications through VSTO


VSTO is included in the Visual Studio 2008 release, which is a set of related libraries and designers for developing applications, along with add-ins for Microsoft Office 2003 and 2007. Microsoft has bundled VSTO 3.0 with Visual Studio 2008 for the first time, which also represents a considerable step forward in the development environment. Previously, developers had to install Visual Studio and VSTO separately in order to build a development environment. Also, it was necessary to perform manual configuration in order to enable debugging for Office solutions.

Microsoft Office remains the best Office application when it comes to automating processes, as well as for using different types of data sources for presenting data to the user. In VSTO 3.0, Microsoft Office tools have become more powerful for presenting data from business applications because Microsoft has made the Office development environment more developer-friendly by creating a new development environment that helps developers to build solutions that function inside Office applications. Thus, Microsoft Office developers are able to easily create solutions that can do more for their business, while reducing costs by reusing existing functionality available in the Office applications.

VSTO can even integrate with your existing ERP system, and increase your enterprise's growth. One leading logistics company has integrated its existing enterprise application with Microsoft Office application using Visual Studio Tools for Office. You can extend your Office client applications by using VSTO and integrate VSTO with the SharePoint Portal to provide enterprise solutions such as Office Business Applications, including Customer Relationship Management, Supply Chain Management, and many others.

The preceding image represents Office 2007 and its extensibility using VSTO 3.0. All of the extensible features of VSTO 3.0 are not common to all of the Office 2007 applications. For example, application-level add-ins are not supported by Access 2007, and custom task panes are not supported by Visio 2007. VSTO documents contain a deployment manifest. The deployment manifest is an XML file that contains a description of the ClickOnce deployment, including the identification of and other information about the current ClickOnce application version that is to be deployed. The location of the VSTO document assembly will be available inside the document's deployment manifest. You can programmatically manipulate the deployment manifest of a document.

VSTO development environment

VSTO 3.0 is not a separate installation package for Visual Studio 2008. VSTO 3.0 reduces the development installation effort for Office developers. While installing Visual Studio 2008, VSTO 3.0 is installed along with the other frameworks and needed components.

Note

You must install the Microsoft .NET Framework 3.5 redistributable package before installing the VSTO 3.0 Runtime. Developing and running Office customizations built with VSTO 3.0 requires the latest version of Microsoft Office 2007.

Package

The VSTO Runtime is installed when installing the Microsoft VSTO 3.0 redistributable package, which is essential for developing and deploying Office solutions using VSTO 3.0. A VSTO 3.0 redistributable package is the framework that brings the power and productivity of Visual Studio 2008 and the .NET framework to business solutions built on the Microsoft Office 2007 application.

The preceding image explains the version history of VSTO, highlighting some of the key differences between the versions. The current release of VSTO supports only the programming languages VB.NET and C#. We can expect other programming languages support in the next version of VSTO.