Add'l Libraries

Visual Studio Tools for Office Second Edition

with Jan Fransen

Course Description: 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.

8+ hours of media runtime

Build VSTO Solutions

Overview: VSTO Versions

VSTO 2005 SE

Choose a Language

VSTO 2005 SE Pre-reqs

First VSTO 2005 SE Project

Solution File Structure

The Document

The Assembly

Demo: Added References

Demo: Event Handlers

Application Level Solution

ThisAddIn

Load an Add-In

Demo: Create an Add-In

Registry Entries

Setup Project

Introduce Managed Code

.NET Framework Examples

.NET Data Types

Work with Strings

Demo: Strings

Retrieve File Information

Demo: Retrieve Files

Demo: Retrieve FileInfo

Demo: Retrieve Path Info

Exception Handling

Demo: Exception Handling

Build Your Own Class

Demo: Simple Class

Windows Forms

Use a Windows Form

Demo: Investigate Form

Data Binding

View Project Properties

View Data Source

Bind to My Namespace

Demo: Add Data Binding

Create Form

Data Source Config Wizard

Save/Test Add-in

Office / Managed Code

Application Object

Demo: Simple Windows App

Props/Methods/Member Obj.

Properties

Methods

Member Objects

Demo: Add a Property

Demo: Create Word Document

Events

Demo: Respond to Events

Word Object Model

Use Word Objects

What's Active?

Demo: This vs Active

Demo: Selection

Work with Ranges

Demo: Ranges

Demo: Small Range

Demo: Paragraph Range

Demo: Insert Text

Collapse Method

Demo: Collapse

Demo: Insert Methods

Demo: Collapse / Insert

Excel Object Model

Use Excel Objects

What's Active?

Casting

Demo: This vs Active

Demo: ActiveSheet

Active Cell/Selection

Demo: Active Cell/Selection

Work With Ranges

Demo: Ranges/Data Region

Item Property

Demo: Item Property

Sub-Range

Demo: Sub-Range

Chart Object

Demo: Create Chart

PowerPoint Object Model

Use PowerPoint Objects

Slides

Demo: New Presentation

Demo: Add New Slide

Shape Object

Text Property

Demo: Text Frame

Demo: Text Range

Demo: Add Bulleted Slide

Command Bars

Demo: Command Bars

C Sharp Techniques

Deal with Parameters

System.Type.Missing

Strongly Type Opt Params

Demo: MsoTriState

Arguments by Ref in Word

Demo: Args by Ref in Word

Excel Accessors/Word PIAs

Parameterized Props in Excel

Variant Parameters in Word

Office File Dialogs

Late-Bound Members

Using Reflection

Create Add-Ins

Shared Add-in Disadvantages

Add-in Advantages

Add-ins for Office 2003

Add-ins for Office 2007

Demo: Create Simple Add-in

Explore VSTO Word Add-In

Run Add-In

Investigate Add-In Code

ChooseDocumentsForm

DocumentFile Class

ThisAddIn Class

Demo: ChooseDocumentForm

Demo: DocumentFile Code

Demo: ThisAddIn Code

PowerPoint Add-In

Demo: Create PPT Add-In

Test PowerPoint Add-In

Customizing the Ribbon

Overview

Ribbon eXtensibility

Ribbon Customization

Demo: Add Ribbon w/Template

Markup for Tabs

Demo: View Control IDs

Markup for Groups

Demo: Markup for Groups

Hook up Ribbon

Demo: Load Ribbon

Demo: Test the Ribbon

Callback Procedures

Demo: Add Callback Procs

Custom Task Pane

Overview

Add Task Pane

Demo: Add Task Pane

Control Visibility

Demo: Control Visibility

Sync Ribbon/Task Pane

Demo: Sync Ribbon/Task Pane

Control Display

Demo: Control Display

Work with Outlook

Use Outlook Objects

Demo: Formatted Email

Demo: Email Attachments

Demo: Create Contact

Navigating Folders

Demo: Move Contact

Demo: Create in Folder

Working with Events

Demo: ItemSend Event

Execute Commands

Use FindControl

Demo: FindControl

Execute Ribbon Control

Find Control IDs

Demo: Find Control ID

Outlook 2007 Features

Work w/Outlook 2007 Data

Use Outlook Stores

Demo: Outlook Stores

Folders

Demo: Iterate Folders

Read Items in Table

Demo: Read Table Items

Restrict Rows

Demo: Restrict Rows

Outlook Form Region

Create Region

Demo: Create Outlook Region

Add Custom Control

Create Add-In

Demo: Create Add-In

Region Manifest/Registry Entry

Demo: Region Manifest

Demo: Registry Entry

Add Ribbon to Form Region

Demo: Add Ribbon

Doc Based Word Solutions

Overview

Doc-Based Architecture

Open a Solution

Base Solution on Template

Demo: Template Based Sol.

Actions Pane

Demo: Add Action Pane

Test Solution

Display/Hide Actions Pane

Task Pane CommandBar Item

Show Actions Pane

Show/Hide Controls

Demo: Hide Actions Pane

Demo: Hide Task Pane

Use WinForms Controls

Demo: WinForms Controls

Host Controls / Data in Word

Why Host Controls?

Overview: Bookmarks

Demo: Bookmark Host Ctrl

View User Control Code

View Document Code

Modify Update Button Code

Test Solution

XMLNode Host Control

Demo: XMLNode Markup

Add XML Schema

Bind Data to Word Doc

DataSets / DataTables

TableAdapters

Demo: Data Binding

View DataSource

View DataSet / DataTables

BindingSource

Work With User Control

View User Control Code

Demo: Add Data Binding

View/Add Data Binding Code

Test Data Binding Doc

Doc Based Excel Solutions

Overview

Doc-Based Architecture

Opening a Solution

Demo: Excel Based Solution

Actions Pane

Demo: Add Action Pane

Test Solution

Display/Hide Actions Pane

Task Pane CommandBar Item

Show Actions Pane

Show/Hide Controls

Demo: Hide Actions Pane

Use WinForms Controls

Demo: WinForms Controls

Host Controls / Data in Excel

Why Host Controls?

Use Excel Ranges

Demo: Named Range Host Ctrl

Bind Data to Excel WB

DataSets / DataTables

TableAdapters

Demo: Data Binding

View Data Source

View DataSet / DataTables

Bind Form Controls

Bind Named Range

Data Tables / Fill Methods

Demo: Add Data Binding

View/Add Data Binding Code

Edit Data Set

Add Methods to Table Adapter

Add Button

Modify Data Bindings

Lists in Excel

Demo: ListObject Control

Add New Data Table

Add Order Details

Conditional Formatting

Test Solution

Deploy Doc Based Solutions

Deployment Pre-reqs

Security

Overview: CASPol.exe

Deployment Models

Demo: Local/Local Deploy

Demo: CASPol.exe

Deploy to Different Folders

Demo: Different Folders

Demo: Modify Manifest

Deploy to Shared Folder

Publish Wizard

Overview: Manifests

Demo: Publish Solution

View Deployment Manifest

View Application Manifest

Demo: Local/Network Deploy

Update Assembly

Demo: Update Assembly

Deploy Add-Ins

Overview

Local Deployment

Demo: Local Deployment

Redeploy Add-In Local

Network Deployment

Demo: Network Deployment

Demo: Update Net. Assembly

Update Network Assembly

Get our entire learning library

ONLY

$49

.99

per year

Visual Studio, ASP.NET, SQL, SharePoint and more...

3,400+ video tutorials
Microsoft MVP's and experts
Future video releases FREE
100% money-back guarantee

Not ready to buy? Try now

Need to train a team?

Our enterprise solution may be your best option.
Check out LearnNowPlus

Toll free: 1-877-960-8132 | Email: info@learnnowonline.com | 10250 Valley View Road Suite 121 | Eden Prairie, MN 55344

Follow Us

Visual Studio Tools for Office Second Edition

Get our entire learning library

ONLY

Visual Studio, ASP.NET, SQL, SharePoint and more...

Features

Support

About

Community