VSTO 3.0 for Office 2007 Programming

Table of Contents

• Preface

• Chapter 1: Visual Studio Tools for Office (VSTO)
  • What is Microsoft VSTO?
  • Why VSTO 3.0?
    • Safer managed code extensions
    • Data caching
    • Feature customization
    • User Interface customization
    • Smart tags
    • WPF support
    • Visual designers
    • Security improvements
    • Maintainability
  • What's new in VSTO 3.0?
  • VSTO architecture
    • Development approaches
      • Document-oriented approach
      • Application-oriented approach
  • VSTO development and deployment
  • Creating Office applications through VSTO
    • VSTO development environment
    • Package
  • Visual Studio integration
    • Creating VSTO solutions
    • Viewing IDE Windows
    • Debugging
  • What can we expect in the next version?
  • Summary

• Chapter 2: Microsoft Office InfoPath Programming
  • Microsoft Office InfoPath
  • InfoPath 2007 in Visual Studio
  • Visual Studio 2008 InfoPath solution overview
    • The VSTO problem when installing Office InfoPath 2007
  • Creating our first example
  • Available customization features
  • Object model in InfoPath solution
    • Understanding the Microsoft Office InfoPath object model
    • Understanding the InfoPath object model functional area
  • Using events in InfoPath
    • Form-level events
    • Xml events
    • Control events
  • Writing event validation for an expense report form
  • Manipulating a data source
    • Fetch node value from main data source
    • Assigning a value to a node in the main data source
    • Adding or creating a new node in the main data source
    • Deleting or removing nodes from the main data source
    • Populating Microsoft Office InfoPath with Microsoft SQL Server 2008
  • Working with Custom Task Panes
    • Managed code
    • Custom Task Pane
    • Creating an InfoPath Task Pane
    • Creating an InfoPath add-in project using Visual Studio 2008
  • InfoPath and SharePoint workflow
  • Summary

• Chapter 3: Microsoft Office Word Programming
  • Microsoft Office Word 2007 solutions
    • Application-level solutions versus document-level solutions
    • Creating document-level solutions
    • Publishing solution deployment
  • Working with objects and documents
    • Working with key objects
      • Inserting text in Word 2007 document
      • Selecting text in a Word 2007 document
      • Creating a table in a Word 2007 document
      • Working with Word templates
  • Actions Pane: Document-level customization
    • Creating a Custom Actions Pane for Microsoft Office Word 2007
      • Managing the Actions Pane
      • Designing the Actions Pane
  • Application-level solutions
    • Task Pane: Application-level customization
    • What is the Task Pane?
    • Custom Task Pane
      • Creating a Custom Task Pane for Microsoft Office Word 2007
  • Programming in Word
    • Word host items
    • Word host controls
    • Adding controls to a document
      • Adding an ActiveX control to Microsoft Office Word 2007 programmatically
      • Data binding to host controls
    • What is LINQ?
      • Using LINQ in Word 2007 with VSTO 3.0 and Visual Studio 2008
  • Customization
    • Ribbon menu
    • Adding controls to menus
    • Toolbar (Quick Access Toolbar)
      • Adding controls to toolbars
  • Summary

• Chapter 4: Microsoft Office Excel Programming
  • Programming in Excel
    • Hello World example using Visual Studio 2008
  • Manipulation
    • Data manipulation
      • Reading worksheet cells
      • Opening a text file as a workbook using VSTO
      • Connecting with Microsoft SQL Server 2008 database
    • Worksheet manipulation
  • Working with ranges
    • Cells
    • Unions
    • Named ranges
  • Excel host items
    • The workbook host item
    • The worksheet host item
    • The ChartSheet host item
  • Excel host controls
    • Chart control
    • The ListObject control
    • The NamedRange control
    • The XMLMappedRange control
    • The SelectionChange event
  • Creating Excel smart tags with VSTO
  • Excel formulae
  • Regular expressions
  • Excel data protection
    • Workbook protection
    • Worksheet protection
  • Summary

• Chapter 5: Microsoft Office Outlook Programming
  • Microsoft Office Outlook object model overview
  • Customization using VSTO
    • Menus in Outlook
  • Outlook form regions support
  • Manipulation
    • Contacts
    • Email messages
  • Working with Appointments
  • Working with meetings
  • Creating a Ribbon menu for Outlook 2007
  • Summary

• Chapter 6: Microsoft Office PowerPoint, Visio, and Project Programming
  • Programming PowerPoint 2007
    • PowerPoint 2007 object model
    • Creating a presentation at runtime
      • Dynamically add a slide and set title text in the presentation
      • Set the presentation theme
    • Ribbons in PowerPoint
      • Ribbon Visual Designer
      • Creating a Ribbon
  • Programming Visio 2007
    • Visio 2007 object model
    • Dynamically creating a new Visio document
      • Adding shapes to a document at runtime
      • Adding a page as a background for another page
    • Set the document theme
    • Creating a Commandbar
  • Programming Project 2007
    • Creating a Project and adding a task dynamically
    • Creating menus for Microsoft Project
    • Creating a Commandbar for Microsoft Project
  • Summary

• Index

Vivek Thangaswamy

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.