Build solutions with Microsoft Office using Visual Basic

Read and understand examples from other sources that are presented in C#

Familiarity with Visual Studio 2003 or 2005 and .NET Framework

Building Solutions with the Microsoft Office System

Creating Your First Visual Studio Tools for Office Project

Taking a Closer Look at an Office Project

Overview

Creating a Word Code-Behind Solution

Adding Code to a Word Event

Build solutions using Visual Studio 2005 Tools for the Microsoft Office system together with the Microsoft Office 2003 system

Create a simple Visual Studio Tools for Office solution

Understand the components that make up a Visual Studio Tools for Office solution

Using COM Objects in a Managed Code Environment

Working with Properties, Methods, and Member Objects

Responding to Events

Using Word Objects

Working with Excel Objects

Navigating Outlook Objects

Overview

Using Active Objects in Excel

Spell-checking a Document on Close

Creating a New Assignment

Understand how unmanaged objects work in a managed code environment

Launch an Office application from a console application

Write code that runs in response to a user’s action

Control some of most commonly used Excel, Work, and Outlook objects through code

Using C# to Work with the Office Object Models

Dealing with Optional Parameters

Sending Arguments by Reference with Word

Exploring Accessors in the Excel and Word PIAs

Using Late-Bound Members

Overview

Highlighting the Data in a Range

Adding a New Document

Spell-Checking a Document

Handle optional parameters in Excel and Word object members

Declare variables and send them by reference when calling Word methods

Explore some of the accessor methods provided by the Word and Excel PIAs to read and change properties

Understand how the System.Reflection namespace can help work late-bound objects at design time

Defining Add-Ins

Creating Your Own Functions with Excel

Building COM Add-Ins in Word and Excel

Creating VSTO Add-Ins in Outlook

Overview

Creating an Excel User-Defined Function

Building a Word Add-In

Creating a VSTO Add-In for Outlook

Understand how an add-in provides application-wide enhancements

Use automation add-ins to provide new functions to Excel

Understand which problems inherent in managed code COM add-ins are solved with Outlook VSTO add-ins

Adding Managed Code to an Office Document

Working with Windows Forms and Controls

Using Host Controls

Overview

Creating an Excel Code-Behind Solution

Restoring a Default View at Startup

Adding a Combo Box to Sort a List

Use the Visual Studio templates available in Visual Studio Tools for Office to create code-behind solutions for Word and Excel

Understand the two files that make up a code-behind solution

Add a Windows Forms control directly to the document in a code-behind project

Understand how host controls add functionality to some commonly used objects in Word and Excel

Introducing the Actions Pane

Adding Multiple Controls with the User Control

Making the Actions Pane Context-Sensitive

Overview

Adding an Actions pane to a Word Solution

Using the Actions Pane to Provide Context-Sensitive Help

Take control of the task pane in Word and Excel

Understand how the ActionsPane control relates to the task pane seen in Word and Excel

Use the user control to design the Actions pane

Add and remove controls from the Actions pane, both at startup and after the user has worked with the document

Setting Up a Data Source

Binding Data to an Excel Workbook

Binding Data to a Word Document

Using Data in the Actions Pane

Overview

Setting Up a Data Source

Implementing an Actions Pane Query UI

Binding a Worksheet List Object

Understand the basics of ADO.NET and how those basics apply to data-driven solutions in Word and Excel

Add a DataSet to a solution and add DataTables based on queries designed rather than stored database objects

Bind a single field to a host control in Word and Excel

Use a control when and with what rows DataTables are filled in a solution

Try out data binding in an Actions pane

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

Overview

Deploying a Solution to a Single Folder

Deploying a Solution’s Document to a Different Folder

Deploying a Strong-Named Solution with the Publish Wizard

Understand deployment models that can be used to share solutions with others

Understand what must be installed on an end-user computer to run solutions

Use manual techniques to deploy a document-based solution

Set a security policy so that a solution can run on the end-user’s computer

Understand how application and deployment manifests work