There are currently no dates scheduled for this course.
Please feel free to register your interest and we'll be sure to let you know once a date is available.
REGISTRATION OF INTEREST
Human Test:
1 + 3 =
Overview:
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. Youll 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.
Pre-requisites:
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#.
At Course Completion:
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
Outline:
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
Course Ratings
Averaged from 6 responses.
Overall Satisfaction
CODE:0-0-NHAVSTO
Choose your nearest New Horizons location below to view our EOCY offers:
