  
                     
|
| |
 |
VISUAL STUDIO 2005 TOOLS FOR MICROSOFT OFFICE
| Course Description |
|
In this course, you will learn how to build Microsoft Office solutions with Visual Studio 2005 Tools for the Microsoft Office System. 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 Actions pane, learn about deploying your solutions to end-user computers, and much more.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
| Familiarity with .NET concepts and the Visual Studio IDE. Previous experience with VBA in Office solutions can be helpful, but is not required.
|
• Getting Started with Visual Studio Tools for Office
Building Solutions with the Microsoft Office System
Types of Visual Studio Tools for Office Solutions
Visual Studio Tools for Office as a Member of the Visual Studio Family
What’s Included in Visual Studio Tools for Office
Choosing a Development Language
Creating Your First Visual Studio Tools for Office Project
Visual Studio Tools for Office Prerequisites
Creating a New Project
Taking a Closer Look at an Office Project
The Moving Parts
Behind the Scenes
• Working with Office Object Models
COM Objects in a Managed Code Environment
Starting at the Top: The Application Object
Working with Properties and Methods, and Other Member Objects
Properties
Methods
Member Objects
Responding to Events
Thinking about Threads
Using Word Objects
Working with Documents
Finding Out What’s Active
Working with Ranges
Inserting Text
Working with Excel Objects
Finding Out What’s Active
Creating Excel Charts
Creating a Chart
Navigating Outlook Objects
Sending an E-Mail Message with CreateItem
Navigating Folders
• Special Techniques for C Programmers
Using C to Work with the Office Object Models
Dealing with Optional Parameters
Sending Arguments by Reference with Word
Accessors in the Excel and Word PIAs
Parameterized Properties in Excel
Methods with Variant Parameters in Word
Accessing the Office File Dialogs
Using Late-Bound Members
Using Reflection
Calling the InvokeHelper Method
• Creating Add-Ins for Office
Add-Ins Defined
Using Your Own Functions with Excel
COM Add-Ins in Word and Excel
Running the Shared Add-In Wizard
Making the Code Product-Specific
Providing a User Interface
Using the Object Model
The Downside of COM Add-Ins
VSTO Add-Ins in Outlook
|
• Building Code-Behind Solutions
Adding Managed Code to an Office Document
Working with Windows Forms and Controls
Using a Window Form in Your User Interface
Using My Settings with a Windows Form
Windows Forms Controls in a Document
Using Host Controls
Working with Bookmarks in Word
Using Excel Ranges
• Working with the Actions Pane
Introducing the Actions Pane
Adding an Actions Pane
Adding Controls
Displaying and Hiding the Actions Pane
Adding Multiple Controls with the User Control
Making the Actions Pane Context-Sensitive
• Creating Data-Driven Solutions
Setting Up a Data Source
Objects You Need to Know
Adding a DataSet, DataTables, and TableAdapters to Your Solution
Binding Data to an Excel Workbook
The BindingSource Object
Single Cell Binding
Working with DataTables and Fill Methods
One to Many Relationships with Lists
Binding Data to a Word Document
Using Data in the Actions Pane
• Deploying Your Office Solution
Sharing Your Solutions with Others
Readying the End-User’s Computer for Your Solution
Security and Office Solutions
Deployment Models for Document-Based Solutions
Deployment Models for Outlook Solutions
Deploying Your First Word or Excel Solution
Deploying the Solution
Granting Full Trust to Your Assembly
Breaking the Solution
Deploying to Different Folders
Editing the Application Manifest
Updating the Locally-Stored Assembly
Deploying the Assembly to a Shared Folder
Breaking the Solution
Deploying with the Publish Wizard
Walking the Communication Path
Updating the Assembly
Deploying an Outlook Add-In
Local Deployment
Updating a Locally-Installed Assembly
Network Deployment
Updating a Network-Installed Assembly
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
