Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Self-Paced Learning    |    Online Training     

Contact Us   -   Why Choose Wintrac   -   Clients    

Order CD-ROMs   Order Videos 
Visual Studio 2005 Tools for Microsoft Office
with Jan Fransen

View the Course Outline

In this course you will learn how to build Microsoft Office solutions with Visual Studio 2005 Tools for the Microsoft Office System.

Course includes 18+ hours of total training time...

  • 6 modules of training
  • Over 6 hours of instruction
  • Over 300 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Visual Studio 2005 Tools for Office
Format Sessions Retail Price



Buy Now!

CD-ROM & Books

6 CD-ROMs + Printed Books

Buy Now!



Buy Now!

DVD-ROM & Books

1 DVD-ROM + Printed Books

Buy Now!

Order online 

Read about Jan Fransen

Course Outline(Outlines are subject to change.)

Visual Studio 2005 Tools for Microsoft Office

Sessions Run Time Pages
6 6 hours 300

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 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.

In this course, you will learn to:

  • 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.
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#.
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

back to top

Your Instructor
Jan Fransen has been working to educate people in the best ways to use Microsoft products for more than 10 years. She's written both data-based and document-based applications for large and small companies, and has helped hundreds of Office users and developers get started on the right foot through public and onsite training classes. As a writer, Jan has developed training courseware, contributed to books on Microsoft Office, written white papers for publication on MSDN, and created samples designed to help developers get up to speed quickly on new Microsoft products and features.

back to top

About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac

Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
© Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy