Troubleshooting issues with loading Office Code Compatibility Inspector (OCCI)


We’ve had a couple people report recently that they are trying to use OCCI but the Inspect VBA Project option never shows up in the Developer ribbon. When installed correctly, OCCI will add the following buttons to the Developer ribbon, like this:

If you have installed OCCI but it’s not showing up in the Developer ribbon, OCCI might be disabled or installed incorrectly. Here are a few things to try:

  • Check to see if the Microsoft Office 2010 Code Compatibility Inspector folder exists under c:\Program Files or c:\Program Files (x86). It it does not, OCCI did not get installed properly.
  • Verify that you installed OCCI as an administrator and that you have the Microsoft .NET Framework 3.5 installed.

You can also verify that OCCI was installed correctly by checking the following locations.

On the splash screen when the application is launched:

 

In the Options dialog box for the application (OCCI is listed in File => Options =>Add-ins): 

 

If you installed OCCI but it’s not showing up in the Add-ins list, it’s possible that the add-in was disabled. For example, the add-in may have been disabled if you clicked Yes after seeing the following message: “Word experienced a serious problem with the ‘Word 2010 Code Compatibility Inspector’ add-in. If you have seen this message multiple times, you should disable this add-in and check to see if an update is available. Do you want to disable this add-in?”

Disabled add-ins are hidden by default but you can view them by selecting Disabled Items in the Manage drop-down menu shown below. For instructions on re-enabling add-ins, see How to: Re-enable an Add-in That Has Been Disabled on MSDN.

 

Still having trouble? Let us know in the Comments section!

 

Comments (7)

  1. Anonymous says:

    Hi Conny,

    The install is per-user only. You cannot install it in the Administrator profile and have it available for the users of the box. You'll need to kick off the installation from an elevated command prompt with msiexe.exe with the user profile logged in.

  2. Anonymous says:

    Conny, here is what one of our consultants had to say:

    References are found in the VBE (Alt+F11) and then click on Tools > References and you will see them listed here. It is possible that these may be a problem in 64-bit so they have been highlighted, as per the information on the form of the OCCI (below).

    "Inspects project references that may need to be reviewed for 64-bit compatibility"

  3. Cornelia Lindenbauer says:

    Hello,

    we tried this tool in our company, but when I want to use this tool as Standarduser, the Menu is not enlarged by VBA-Inspector. This is just happening if the Administrator is logged in. As in our company this tool should be used by Developers, this appears a problem. Is the OCCI not concepted for Standard User or did we just forget an adjustment?

    kind regards

    Conny

  4. Cornelia Lindenbauer says:

    Hello,

    I have tried to intall the OCCI on a workstation in our department as Admin User, and then the Menu was extended with "VBA-Inspector". But when I tried to sign in as Standard User it did not appear. As we need this program for the developers, and not for the Admins I wanted to ask if I just forgot an adjustment or if the tool is just for Admin  use?

    kind regards

  5. Hello says:

    Thank you for your quick answer, everything works fine now.

    I have just one more question about how to handle the summary, when you run the tool you get a summary with:

    Total lines scanned

    Total items found

    Deprecated items

    Changed items  

    Redesigned items

    Declare statements

    References Found

    The last line, references found is on none of the pages, where the tool and its function is described, I looked at and I have no definite idea what these references are or what the problem with them is. As the OCCI found 4 references within one of my macros I would appreciate an advise from you.

    kind regards

    Conny

  6. Geof says:

    I ran OCCI2010Update1.msi, opened Excel 2007, Office button, Excel options, Add-Ins, Manage COM Add-ins, Go, Microsoft Excel CCI checkbox unchecked. Checked it, saw the Load Behavior: Not loaded. The Managed Add-in Loader failed to initialize.

  7. Manideep says:

    I have installed the OCCI..with Administrator Privileges.. BUt i am unable to see it in the excel. Can someone really guide me how to install this and how it works..