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 Tools for Microsoft Office Second Edition
with Jan Fransen

View the Course Outline

This course is designed for developers who want to develop document-based solutions for Microsoft Word 2003 or Microsoft Excel 2003, or add-ins for most Microsoft Office 2003 and Microsoft Office 2007 products. 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 task pane, learn about deploying your solutions to end-user computers, and much more.

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

  • 8 modules of training
  • Over 7 hours of instruction
  • Over 450 pages of printable courseware
  • Step-by-step hands-on-labs
  • Sample code
Format Modules Retail Price
Visual Studio Tools for Microsoft Office 2nd Ed.

CD-ROM

8 CD-ROMs

$495.00
Buy Now!

CD-ROM & Books

8 CD-ROMs + Printed Books

$591.00
Buy Now!

DVD-ROM

1 DVD-ROM

$495.00
Buy Now!

DVD-ROM & Books

1 DVD-ROM + Printed Books

$591.00
Buy Now!

Order online 

Read about Jan Fransen

Course Outline(Outlines are subject to change.)

Visual Studio Tools for Microsoft Office Second Edition

Modules Run Time Pages
8 7 hours 450

This course is designed for developers who want to develop document-based solutions for Microsoft Word 2003 or Microsoft Excel 2003, or add-ins for most Microsoft Office 2003 and Microsoft Office 2007 products. 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 task pane, learn about deploying your solutions to end-user computers, and much more.


In this course, you will learn to:

  • Create add-ins and document-based solutions for Office.
  • Know which products and components need to be installed on both development and end-user computers to create and use Office solutions.
  • Use the .NET Framework to save coding time.
  • Understand the Word, Excel, PowerPoint, and Outlook object models and how they mirror the interactive environment.
  • React to events triggered by the Office user.
  • Perform Office-related tasks such as sending an email or building a spreadsheet through code.
  • Translate Office programming concepts between Visual Basic and C#
  • 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#.
Introduction
  • Prerequisites
  • Installing the Practice Files
  • About the Author
Getting Started with VSTO
  • Building Solutions with VSTO 2005 SE and the Microsoft Office System
  • Creating your first VSTO 2005 SE 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

back to top


Your Instructor
Jan Fransen has been working to educate people in the best ways to use Microsoft products for more than 15 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