2052: Using Visual Studio for Office Tools (1 day)
About this Course
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.
Audience Profile
This course is intended for existing Visual Studio .NET application developers with Office development experience. A secondary audience consists of existing .NET solution developers.
At Course Completion
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
Course Outline
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 ObjectsAfter 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 WordAfter 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 ExcelAfter 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 SolutionsAfter completing this module, students will be able to:
- Secure a solution.
- Deploy a solution.
- Update a solution.