CERTIFICATIONS

PROGRAMS

LEARN > Find a Class > Class Summary

AT-VSOFF - Visual Studio 2005 Tools for Microsoft Office

If you have any questions about registering for this class, please call (877) 832-0688 Ext. 1493 or email us at getsmart@LRS.com

This course is designed for developers who want to develop solutions based on Microsoft Word 2003, Microsoft Excel 2003, or Microsoft Outlook 2003. You’ll learn about the types of solutions you can create with Visual Studio Tools for Office, understand how to 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.

Click here for a printer-friendly version of this page

Prerequisites

This course 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#.

Detailed Class Syllabus

Getting Started with VSTO

Building Solutions with the Microsoft Office System

Creating Your First Visual Studio Tools for Office Project

Taking a Closer Look at an Office Project

Working with Office Object Models

COM Objects in a Managed Code Environment

Working with Properties and Methods, and Other Member Objects

Responding to Events

Using Word Objects

Working with Excel Objects

Navigating Outlook Objects

Special Techniques for C# Programmers

Dealing with Optional Parameters

Sending Arguments by Reference with Word

Accessors in the Excel and Word PIAs

Using Late-Bound Members

Creating Add-Ins for Office

Add-Ins Defined

Using Your Own Functions with Excel

COM Add-Ins in Word and Excel

VSTO Add-Ins in Outlook

Building Code-Behind Solutions

Adding Managed Code to an Office Document

Working with Windows Forms and Controls

Using Host Controls

Working with the Actions Pane

Introducing the Actions Pane

Adding Multiple Controls with the User Control

Making the Actions Pane Context-Sensitive

Creating Data-Driven Solutions

Setting Up a Data Source

Binding Data to an Excel Workbook

Binding Data to a Word Document

Using Data in the Actions Pane

Deploying Your Office Solution

Sharing Your Solutions with Others

Deploying Your First Word or Excel Solution

Deploying to Different Folders

Deploying with the Publish Wizard

Deploying an Outlook Add-In