Using Microsoft Visual Studio Tools for the Microsoft Office System

Target Audience
This course is intended for existing Visual Studio .NET application developers with Office development experience. A secondary audience consists of existing .NET solution developers

Pre-Requisites
Before attending this course, students must have:Experience with the Microsoft Visual Studio .NET development environment.Experience with the Microsoft .NET Framework 1.0 or 1.1.Experience using either Microsoft Visual Basic® .NET or Microsoft Visual C#® .NET.Experience using Microsoft Office products such as Microsoft Word or Microsoft Excel.Some awareness of the Word and Excel object models.

Purpose
This one-day instructor-led course provides students with the knowledge and skills to develop solutions using Microsoft Visual Studio® Tools for Office. This learning product assumes that the .NET developer has an awareness of the Office application object models

Course outline

1. Using Visual Studio Tools for the Microsoft Office System
2. Developing Solutions for Word 2003
3. Developing Solutions for Excel 2003
4. Securing, Deploying, and Updating Visual Studio Tools for Office Solutions

Module 1:Using Visual Studio Tools for the Microsoft Office System

• In this module, students will learn about using Visual Studio Tools for Microsoft Office System. They will learn how the architecture of the tools allows them to use the .NET Framework functionality and security in solutions that use Excel and Microsoft Word as a user interface.
• Lessons
• What are the Visual Studio Tools for the Microsoft Office System? Architecture of Visual Studio Tools for Office Solutions Using Visual Studio Tools for Office Project Templates Programming Office Using Visual Basic .NET and Visual C# .NET Using Office Objects
• Lab: Using Visual Studio Tools for Office Project Templates and Office Objects
• After completing this module, students will be able to:
• Describe the components of the Visual Studio Tools for Microsoft Office System.
• Describe the architecture of Visual Studio Tools for Microsoft Office System solutions.
• Create solutions using the Visual Studio .NET project templates.
• Use Visual Basic .NET and Visual C# .NET to develop Office solutions.
• Use objects provided by the Office object model

Module 2:Developing Solutions for Word 2003

• In this module, students will learn about the structure of a default Word project and how they can use objects from the Word object model and the .NET Framework class libraries to create useful Word solutions.
• Lessons
• Using Word Project Assemblies Using Word Objects Working with .NET Framework Classes
• Lab: Developing Solutions for Word
• After completing this module, students will be able to:
• Use the properties and code in the Word project template.
• Programmatically control the Word application and documents in it.
• Use the .NET Framework classes in Visual Studio Tools for Office Word projects

Module 3:Developing Solutions for Excel 2003

• In this module, students will learn about the structure of a default Excel project and how they can use objects from the Excel object model and the .NET Framework class libraries to create useful Excel solutions.
• Lessons
• Using Excel Project Assemblies Using Excel Objects Working with .NET Framework Classes
• Lab: Developing Solutions for Excel
• After completing this module, students will be able to:
• Use the properties and code in the Excel project template.
• Programmatically control the Excel application and workbooks in it.
• Use the .NET Framework classes in Visual Studio Tools for Office Excel projects.

Module 4:Securing, Deploying, and Updating Visual Studio Tools for Office Solutions

• In this module, students will learn about the Visual Studio Tools for Office security and learn the advantages that each deployment model provides.
• Lessons
• Securing Solutions Deploying Solutions Updating Solutions
• Lab: Securing and Deploying Solutions
• After completing this module, students will be able to:
• Secure a solution.
• Deploy a solution.
• Update a solution.