VSTO Training: Visual Studio Tools for Microsoft Office Second Edition

Course Number: VS-100
Duration: 2 days
view class outline

VSTO Training Overview

Accelebrate's VSTO training is designed for developers who want to develop solutions based on Microsoft Office 2003 or 2007, using Visual Studio Tools for Microsoft Office Second Edition. You'll learn about the types of solutions you can create with Visual Studio Tools for Office, understand how work with the Office object models, find out how to create your own user interface through Windows forms or the Actions pane, learn about deploying your solutions to end-user computers, and much more.

Location and Pricing

Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.

In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=categorygroup&page=microsoft.

VSTO Training Prerequisites

Accelebrate's Visual Studio 2005 Tools for Microsoft Office (VSTO) training is designed for developers who have a programming background and are familiar with .NET concepts and the Visual Studio IDE. Previous experience with VBA in Office solutions can be helpful, but is not required. Most examples are presented in Visual Basic, but a C# topic is included to help C# developers translate the concepts to their language of choice, and to give Visual Basic developers the tools they need to read and understand examples available from other sources that are presented in C#.

Hands-on/Lecture Ratio

This training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 15 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.

VSTO Training Materials

All attendees receive more than 250 pages of comprehensive, illustrated courseware and a copy of Professional Visual Studio 2005 Tools for Office.

Software Needed on Each Student PC

Microsoft Office 2003 or later (complete install)
Microsoft Visual Studio 2005 SP1 + Visual Studio Tools for Microsoft Office Second Edition
Please contact us for additional setup instructions

VSTO Training Objectives

Know which products and components need to be installed on both development and end-user computers to create and use Office solutions.
React to events triggered by the Office user.
Perform Office-related tasks such as sending an e-mail or building a spreadsheet through code.
Translate Office programming concepts between Visual Basic and C#.
Create add-ins and code-behind solutions for Office.
Use data in your Word and Excel solutions.
Deploy your solutions to an end-user computer.

VSTO Training Outline

Getting Started with VSTO

Building Solutions with VSTO 2005 SE and the Microsoft Office System
Creating Your First Visual Studio Tools for Office Project
Introducing Managed Code

Working with the Microsoft Office Object Models

COM Objects in a Managed Code Environment
Working with Properties, Methods, and Member Objects
Responding to Events
Using Word Objects
Working with Excel Objects
Microsoft PowerPoint Objects
Building Command Bars in Office 2003

Techniques for C# Programmers Working in Office

Using C# to Work with the Office Object Models
Dealing with Parameters
Accessors in the Excel and Word PIAs
Using Late-Bound Members

Creating Add-Ins for Microsoft Office

The VSTO SE Add-In Model
Creating an Add-Ins with VSTO 2005 SE
Customizing the Ribbon in Office 2007
Custom Task Panes in Office 2007

Building Outlook Solutions

Creating an Outlook Add-In
Navigating the Outlook Object Model
Working with Outlook 2007 Data
Taking Advantage of Outlook Form Regions in Outlook 2007

Document-Based Solutions with Word

Building Document-Based Solutions for Word
Working with Host Controls in Word
Binding Data to a Word Document

Building Document-Based Solutions for Excel

Building Document-Based Solutions for Excel
Working with Host Controls in Excel
Binding Data to an Excel Workbook

Deploying your VSTO Solution

Sharing your Solutions with Others
Deploying Document-Based Solutions
Deploying VSTO 2005 SE Add-Ins
Customizing a Setup Project

Conclusion

VB.NET, C#, ASP, & ASP.NET Training

Java Training

SQL Server Training
SharePoint Training

Adobe Training

“Accelebrate,” “Accelerated Learning Celebrated Results,” and the Accelebrate logo are registered trademarks of Accelebrate, Inc. All other product names and trademarks are property of their respective owners. Course outline content may mirror or be derived from the book that each student receives with the course. Otherwise, all content is copyright © 2003- by Accelebrate, Inc. of Atlanta, Georgia, USA. To contact us, please use the contact form, email info@accelebrate.com us, or call 1 877 849 1850 in the US and Canada, 0808 234 2132 in the UK, 1 800 550 311 in Ireland, or +1 678 648 3113 from all other locations.