This course is designed for developers who want to develop solutions based on Microsoft Word 2003, Microsoft Excel 2003, or Microsoft Outlook 2003. You’ll 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.In this course you will learn to...
- Know which products and components need to be installed
on both development and end-user computers to create and use Office solutions.
- React to events triggered by the Office user.
- Perform Office-related tasks such as sending an e-mail
or building a spreadsheet through code.
- Translate Office programming concepts between Visual
Basic and C#.
- Create add-ins and code-behind solutions for Office.
- Use data in your Word and Excel solutions.
- Deploy your solutions to an end-user computer.
Prerequisites: 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#.
Getting Started with VSTO
-
Building Solutions with the Microsoft Office System
-
Creating Your First Visual Studio Tools for Office Project
-
Taking a Closer Look at an Office Project
Working with Office Object Models
- COM
Objects in a Managed Code Environment
-
Working with Properties and Methods, and Other Member Objects
-
Responding to Events
- Using
Word Objects
-
Working with Excel Objects
-
Navigating Outlook Objects
Special Techniques for C# Programmers
-
Dealing with Optional Parameters
-
Sending Arguments by Reference with Word
-
Accessors in the Excel and Word PIAs
- Using
Late-Bound Members
Creating Add-Ins for Office
-
Add-Ins Defined
- Using
Your Own Functions with Excel
- COM
Add-Ins in Word and Excel
- VSTO
Add-Ins in Outlook
Building Code-Behind Solutions
-
Adding Managed Code to an Office Document
-
Working with Windows Forms and Controls
- Using
Host Controls
Working with the Actions Pane
-
Introducing 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
-
Binding Data to an Excel Workbook
-
Binding Data to a Word Document
- Using
Data in the Actions Pane
Deploying Your Office Solution
-
Sharing Your Solutions with Others
-
Deploying Your First Word or Excel Solution
-
Deploying to Different Folders
-
Deploying with the Publish Wizard
-
Deploying an Outlook Add-In
Your InstructorJan Fransen has been working to educate people in the best ways to use Microsoft products for more than 15 years. She's written both data-based and document-based applications for large and small companies, and has helped hundreds of Office users and developers get started on the right foot through public and onsite training classes. As a writer, Jan has developed training courseware, contributed to books on Microsoft Office, written white papers for publication on MSDN, and created samples designed to help developers get up to speed quickly on new Microsoft products and features.
|
