News - Office 2010 compatibility issues with MS Excel add-ins - Warning and Solution

We upgraded to  MS Office 2010 recently and our add-ins/xla's stopped compiling, throwing an Object Error Invalid error. This is seen when VB controls are used in the vba projects. The error occurs because new versions of the VB6.0 runtime files have been installed. When the controls are used in Excel a corresponding EXD file is created. However, these EXD files will be referring to the old versions of the controls still.

To fix the problem delete the existing EXD files, and then the addin should work correctly. The files can be found under C:\Users\\AppData\Roaming\Microsoft\Forms