LearnDevNow

 

Subscribe Now

Visual Studio 2005 Tools for Office

with Jan Fransen


Course Description: This course is designed for developers who want to develop solutions based on Microsoft Word 2003, Microsoft Excel 2003, or Microsoft Outlook 2003. You will 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.



6+ hours of media runtime

Getting Started

  • Types of Office Solutions
  • Visual Studio Tools for Office
  • VSTO - Part of VS Family
  • What's Included in VSTO?
  • Development Language
  • VSTO Prerequisites
  • Checking Your Installation
  • Create a VSTO Project
  • What the Project Created
  • Document Changes
  • The Assembly
  • Behind the Scenes
  • Added References
  • Other Events

Object Models

  • The Application Object
  • Req. for Automation Solutions
  • Automation Solution Demo
  • Properties and Methods
  • Member Objects
  • Add a Document Demo
  • Responding to Events
  • Threads

Word Object Model

  • Using Word Objects
  • ActiveDocument
  • Word Object Model Demo
  • Word's Range Object
  • Range Object Demo
  • Insert a Range
  • Insert Methods of a Range

Excel Object Model

  • Working with Excel Objects
  • ActiveWorkbook & This...
  • ActiveSheet
  • ExcelObjectModel Demo
  • ActiveCell and Selection
  • Selection in Charts
  • Excel Ranges
  • CurrentRegion
  • The Item Property
  • Working with a Sub-Range
  • Chart Object
  • Use the Macro Recorder

Outlook Object Model

  • Navigating Outlook Objects
  • E-Mailing with CreateItem
  • Add a Contact
  • Navigating Folders
  • NameSpace Object
  • Moving Items in Folders

C# Techniques

  • Optional Parameters
  • Using Opt. Param. in Code
  • Arguments by Reference
  • Word Arguments by Ref
  • Close Event
  • Accessors in PIAs
  • Parameterized Properties
  • Variant Parameters
  • Styles.get_Item
  • Accessing File Dialogs
  • Late-Bound Members
  • Using Reflection

Creating Add-Ins

  • Automation Add-In
  • Automation Walkthrough
  • COM Add-Ins
  • Excel COM Add-In
  • Providing a User Interface
  • Get & Print Sheets
  • COM Add-In Downside
  • Check for Attachment

Code-Behind Solutions

  • Code-Behind Templates
  • Code-Behind Classes
  • Code-Behind Architecture
  • The Assembly
  • Create Code-Behind Solution
  • Add a WinForm to the UI
  • Settings
  • Add WinForm Controls
  • Host Controls
  • Excel Host Control
  • Word Host Control

Working with Actions Pane

  • Introducing the Actions Pane
  • Build an Actions Pane in Code
  • Running the Actions Pane
  • Adding Multiple Controls
  • Context Sensitive Actions Pane
  • Writing Event Code
  • Custom Action Pane Available

VS Data Sources

  • Objects You Need to Know
  • DataSets and DataTables
  • TableAdapters
  • Create a SQL Data Source
  • Binding Data to Host Controls
  • DataTables and Fill Methods
  • Configure Data Source
  • Adding Order Details
  • Add Custom Formatting

Data Binding in Word

  • Sample Solution
  • Replace Bookmarks with Data
  • 1st Iteration of the Solution
  • Add a DataGridView
  • Creating an Actions Pane

Deployment

  • Deployment Models
  • End-User's Computer
  • DeployMe Demo
  • Security & Office Solutions
  • Move/Rename Deployed Docs
  • Edit the Application Manifest
  • Change User Trust Perm.
  • Deploying Changes
  • Deploy Asm. to Shared Folder
  • Strong Name
  • DLL Version Info

Publish Wizard

  • Publish Wizard Overview
  • Updating with Publish Wizard
  • Assembly Update Recap
  • Deploy an Outlook Add-In
  • Network Deployment
  • Change Network Deployment

Get our entire learning library

ONLY

$99
.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
LearnNowExpress

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 Subscribe to our blog Friend us on Facebook Follow us on Twitter Visit us on LinkedIn Subscribe to us on YouTube
© 2012 LearnNow, LLC. All Rights reserved. Various trademarks held by their respective owners. terms of use | privacy policy