Microsoft has updated Office Code Compatibility Inspector (OCCI). The tool helps you troubleshoot compatibility issues in your Microsoft Visual Basic for Application (VBA) Macros and add-ins created in previous versions of Microsoft Office.
OCCI is designed to help update Visual Basic for Applications (VBA) and Visual Studio Tools for Office code so that it is 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.
The Inspector does not 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.