2052 - Using Visual Studio for Office Tools

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

After completing this course, students will be able to:

• Use Visual Studio Tools for the Microsoft Office System
• Develop Visual Studio Tools for Office solutions for Word 2003
• Develop Visual Studio Tools for Office solutions for Excel 2003
• Secure, deploy and update 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

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

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