Free Sample
+ Collection

VSTO 3.0 for Office 2007 Programming

Vivek Thangaswamy

Get to grips with Programming Office 2007 using Visual Studio Tools for Office
RRP $20.99
RRP $34.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781847197528
Paperback260 pages

About This Book

  • A step-by-step guide for brand-new Office developers who want to explore programming with VSTO
  • Precise information on programming in Microsoft InfoPath, Word, Excel, PowerPoint, Outlook, Visio, and Project 2007 using VSTO
  • Create your own fully featured Office extensions
  • Packed with easy-to-follow examples covering all the Office applications

Who This Book Is For

This book is aimed at .NET developers, familiar with C#, who want to get to grips with programming Office 2007. The book will also be useful for those of you who already have experience with VBA and programming Office, but are ready to take the next step into the more powerful world of Office programming with VSTO.

Table of Contents

Chapter 1: Visual Studio Tools for Office (VSTO)
What is Microsoft VSTO?
Why VSTO 3.0?
What's new in VSTO 3.0?
VSTO architecture
VSTO development and deployment
Creating Office applications through VSTO
Visual Studio integration
What can we expect in the next version?
Chapter 2: Microsoft Office InfoPath Programming
Microsoft Office InfoPath
InfoPath 2007 in Visual Studio
Visual Studio 2008 InfoPath solution overview
Creating our first example
Available customization features
Object model in InfoPath solution
Using events in InfoPath
Writing event validation for an expense report form
Manipulating a data source
Working with Custom Task Panes
InfoPath and SharePoint workflow
Chapter 3: Microsoft Office Word Programming
Microsoft Office Word 2007 solutions
Working with objects and documents
Actions Pane: Document-level customization
Application-level solutions
Programming in Word
Chapter 4: Microsoft Office Excel Programming
Programming in Excel
Working with ranges
Excel host items
Excel host controls
Creating Excel smart tags with VSTO
Excel formulae
Regular expressions
Excel data protection
Chapter 5: Microsoft Office Outlook Programming
Microsoft Office Outlook object model overview
Customization using VSTO
Outlook form regions support
Working with Appointments
Working with meetings
Creating a Ribbon menu for Outlook 2007
Outlook 2007 data interaction with Microsoft SQL Server 2008
Chapter 6: Microsoft Office PowerPoint, Visio, and Project Programming
Programming PowerPoint 2007
Programming Visio 2007
Programming Project 2007

What You Will Learn

  • Enhance Office applications with the features of VSTO
  • Learn Microsoft Office InfoPath programming in Visual Studio and discover its role in SharePoint Workflow
  • Get confident with Microsoft Word Programming in Visual Studio 2008, working with task panes, menus, toolbars, and ribbons
  • Build a Microsoft Excel solution in Visual Studio, process data with Microsoft SQL Server 2008, and work with host items in Excel and charts
  • Customize Microsoft Outlook using VSTO, work with Ribbons for Outlook 2007, and understand SQL server database interaction
  • Explore Programming in PowerPoint using VSTO 3.0 including creating presentations, adding slides, ribbons, and using Visual designer for ribbons
  • Learn Programming in Visio and Project 2007 using VSTO 3.0

In Detail

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.


Read More