Tuesday, December 01, 2009

Office 2010 Tool: Compatibility Inspector

The Microsoft Office 2010 Compatibility Inspector compares legacy code against the Office 2010 object model by using a text search for known properties and methods that have changed. You can run the tool against specific projects. You also have the option to mark those areas in the code where text search has identified a possible object model match. The comment will include description of what was found along with possible remediation link to online content or help. The tool integrates with both Microsoft Visual Basic for Applications 7.0 (VBA 7) and Microsoft Visual Studio 2008. It includes a basic scanner where definitions and remediation links are updated from a central online location. It also generates a summary report and a details report. The summary includes the total lines of code scanned as well as total lines identified as potential candidates for object model changes. The details report includes the module name, line number, and links to remediation for each identified issue along with color-coded flags for impact guidance.

The tool checks compatibility for code written for the following Office applications for use with Microsoft Office 2010
  • Microsoft Excel 2010
  • Office 97
  • Office 2000
  • Office XP
  • Office 2003
  • Office 2007
You need have the following applications installed:

Microsoft .NET Framework 2.0
Microsoft Office Excel 2007
-OR-