Office Compatibility Tools: Office Code Compatibility Inspector and Office Environment Assessment Plus OEAT Guide

Microsoft is offering two new tools offered designed to deal with potential compatibility issues in scenarios involving migration to Office 2010 or the adoption of Office 365.First, the Microsoft Office Code Compatibility Inspector is designed to help update Visual Basic for Applications (VBA) and Visual Studio Tools for Office code so that it's compatible with […]

Microsoft is offering two new tools offered designed to deal with potential compatibility issues in scenarios involving migration to Office 2010 or the adoption of Office 365.

First, the Microsoft Office Code Compatibility Inspector is designed to help update Visual Basic for Applications (VBA) and Visual Studio Tools for Office code so that it's compatible with Office 2010 and Office Pro Plus for Office 365. It consists of four add-ins that load, one add-in per application, in Excel 2010, PowerPoint 2010, Word 2010, and Visual Studio 2008 or Visual Studio 2010," informs Microsoft.

"The Inspector doesno' correct code; it inspects code, and then comments specific lines of code that reference items in the object model that have been changed, removed, or deprecated. You can then modify the code based on the comments, or use the links that are provided in the comments to view topics on the Web that are pertinent to a particular line of your code," the software company stated.

Second, "Office Compatibility and the Office Environment Assessment Tool (OEAT) scans client computers for add-ins and applications that interact with Office 97, Office 2000, Office XP, Office 2003, the 2007 Office system, and Office 2010. You use OEAT during the assessment phase of an Office 2010 or Office Professional Plus for Office 365 deployment project," revealed the Redmond company.

The tool is capable of assessing:

  • Office add-ins that are currently installed
  • Programs that are not registered as add-ins but still interact with Office programs
  • Information about client computers, such as processor models and types (32-bit or 64-bit), free disk space, Windows version, and Office version
  • Report: Add-ins assessment--list of third party programs and information about the compatibility of those programs with Office 2010.
  • Report: Environmental assessment (potential upgrade issues).

Microsoft is also offering, Office Environment Assessment Tool (OEAT) user's guide for Office 2010.

"This user's guide for the Office Environment Assessment Tool (OEAT) will help you work successfully with OEAT. Before you use this guide, we recommend that you perform the planning steps described in Office 2010 application compatibility guide and that you are ready to run OEAT to scan your organization's client computers for add-ins and applications that interact with Microsoft Office," Microsoft said.

You can download OCCI here, and OEAT by visiting here. And, the Office Environment Assessment Tool (OEAT) user's guide for Office 2010 is available here.