VSTO 3.0 for Office 2007 Programming


VSTO 3.0 for Office 2007 Programming
eBook: $20.99
Formats: PDF, PacktLib, ePub and Mobi formats
$17.85
save 15%!
Print + free eBook + free PacktLib access to the book: $55.98    Print cover: $34.99
$52.84
save 6%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • A step-by-step guide for brand-new Office developers who want to explore programming with VSTO
  • Precise information on programming in Microsoft InfoPath, Word, Excel, PowerPoint, Outlook, Visio, and Project 2007 using VSTO
  • Create your own fully featured Office extensions
  • Packed with easy-to-follow examples covering all the Office applications

Book Details

Language : English
Paperback : 260 pages [ 235mm x 191mm ]
Release Date : March 2009
ISBN : 1847197523
ISBN 13 : 9781847197528
Author(s) : Vivek Thangaswamy
Topics and Technologies : All Books, Microsoft Development , Other, Enterprise, Microsoft, .NET


Table of Contents

Preface
Chapter 1: Visual Studio Tools for Office (VSTO)
Chapter 2: Microsoft Office InfoPath Programming
Chapter 3: Microsoft Office Word Programming
Chapter 4: Microsoft Office Excel Programming
Chapter 5: Microsoft Office Outlook Programming
Chapter 6: Microsoft Office PowerPoint, Visio, and Project Programming
Index
  • 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

Vivek Thangaswamy

Vivek Thangaswamy is a Software Solution developer and technical author living and working in the enjoyable surroundings of Chennai city, in India. His range of technical competence stretches across platforms and lines of business, but he specializes in Microsoft enterprise application architectures and Microsoft server-based product integrations. Vivek is currently working for the world's largest software services company in Microsoft Technologies. He holds several Microsoft certifications and Microsoft MVP awards. He has completed his Bachelor of technology degree in Information Technology from one of the world's finest universities and is currently pursuing a Management of Business Administration in Finance degree. Vivek loves spending time with friends and writing poems in his mother tongue.

Sorry, we don't have any reviews for this title yet.

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.

Frequently bought together

VSTO 3.0 for Office 2007 Programming +    SugarCRM Developer's Manual: Customize and extend SugarCRM =
50% Off
the second eBook
Price for both: $27.00

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Enhance Office applications with the features of VSTO
  • Learn Microsoft Office InfoPath programming in Visual Studio and discover its role in SharePoint Workflow
  • Get confident with Microsoft Word Programming in Visual Studio 2008, working with task panes, menus, toolbars, and ribbons
  • Build a Microsoft Excel solution in Visual Studio, process data with Microsoft SQL Server 2008, and work with host items in Excel and charts
  • Customize Microsoft Outlook using VSTO, work with Ribbons for Outlook 2007, and understand SQL server database interaction
  • Explore Programming in PowerPoint using VSTO 3.0 including creating presentations, adding slides, ribbons, and using Visual designer for ribbons
  • Learn Programming in Visio and Project 2007 using VSTO 3.0

In Detail

With the arrival of Visual Studio Tools for Office 3.0 (VSTO), developers can now program Microsoft Office from the .NET framework. There are huge books in the market that give loads of unnecessary information but are of no real help to brand-new Office developers. Wouldn't it be great to have a precise book that simply covers the basics and introduces programming Office 2007 with VSTO using the latest version of Visual Studio? This is that book.

VSTO 3.0 for Office 2007 Programming shows you how to write Office 2007 applications with Visual Studio Tools for Office 3.0. Learn how to automate tasks in InfoPath, Word, Excel, Outlook, PowerPoint, Visio, and Project 2007 with greater programming power and flexibility than was available from the VBA language. With this book and the mastery of VSTO you will learn, Office will no longer be an application to you; it will be a platform for developing custom applications.

VSTO 3 is the most recent version of VSTO, making use of Visual Studio 2008, and working with Office 2007. This book shows how VSTO puts Office automation into the hands of developers, allowing them to use the power of the .NET framework to automate Office applications thus increasing the speed of the applications, their security, and the opportunity to use other parts of the .NET Framework such as its data handling capabilities.

This book builds a solid programming foundation in VSTO for brand-new Office developers. You will leave behind the world of VBA programming and take your first steps into the powerful and exciting world of using C# to create Office 2007 applications. Packed with examples and covering all the main Office applications, this book will have you creating fully featured Office extensions before you know it.

A step-by-step guide for brand-new Office developers who want to explore programming with VSTO

Approach

This book contains complete step-by-step instructions and simple explanations about VSTO programming of entire Office applications. It covers the concepts of VSTO, VSTO architecture, its features, and versions using practical examples, to help beginners and intermediate developers develop real-world Office applications. Separate chapters cover programming InfoPath, Word, Excel, Outlook, and PowerPoint.

Who this book is for

This book is aimed at .NET developers, familiar with C#, who want to get to grips with programming Office 2007. The book will also be useful for those of you who already have experience with VBA and programming Office, but are ready to take the next step into the more powerful world of Office programming with VSTO.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software