Application Compatibility Lab

Version: 1.0.0

Description

In this lab you will use the Office compatibility tools to evaluate the current environment and existing Office Add-in code. Using these tools will help identify potential problems in Office Add-ins and suggest solutions. Please note that Demos are in the Source folder.

Overview

In these lab exercises, you will use the Office compatibility tools to evaluate the current environment and existing Office Add-in code. Using these tools will help identify potential problems in Office Add-ins and suggest solutions.

Objectives

In this lab you will:

  • Use the Office Environment Assessment Tool to scan the network
  • Learn to use the VBA scanner to scan existing VBA applications
  • Learn to use the Visual Studio Code scanner to scan existing Office Add-ins

System Requirements

You must have the following items to complete this lab:

  • Microsoft® Windows® Vista SP1 or Microsoft® Windows Server 2008 (64-bit)
  • Microsoft® Office Professional Plus 2010 (32-bit or 64-bit)
  • Microsoft® Visual Studio 2010

Exercises

This Hands-On Lab is comprised of the following exercises:

  1. Assessing the environment using the OEAT
  2. Using the Office 2010 Compatibility Inspector Tool

Estimated time to complete this lab: 30 minutes.

Starting Materials

This Hands-On Lab includes the following starting materials.

  • Sample Documents and Add-Ins. The lab provides the following sample files and addins to inspect using the application compatibility tools.
    • %Office2010DeveloperTrainingKitPath%\Labs\AppCompatibility\Source\Starter\Demo File.ppt: This is a PowerPoint presentation containing VBA Code.
    • %Office2010DeveloperTrainingKitPath%\Labs\AppCompatibility\Source\Starter\Excel2007AddIn: This is a sample Excel Add-in project for Excel 2007.