BAM Excel Add-In for Excel 2007 – This workbook has lost its VBA project, ActiveX controls and any other programmability-related features

Posted: August 17, 2010 in BizTalk
Tags: , , , ,

I have installed and enabled BAM Excel Add-in in Excel 2007. Now when I start Excel I get the following error message:

“Repairs to BAM.xla’
Excel was able to open the file by repairing or removing the unreadable content.
This workbook has lost its VBA project, ActiveX controls and any other programmability-related features”

CAUSE

  • You get this error because during the installation of MS Office 2007, “Visual Basic for Application” was not installed.

SOLUTION

  • To solve this you need to change your installation of MS Office.
    • Close Excel if it is open.
    • In the Control Panel choose “Add or Remove Programs”
    • Select Microsoft Office in the list and click on the Change button.
    • Choose “add or remove features” and press “Continue”

excel-addfeactures-1

    • Select “Visual Basic for Applications” in the “Office Shared Features” list and set it to “Run from My Computer”. Then click on the continue button.

excel-addfeactures-2

After the installation is finished you will be able to use BAM Excel Add-In.

Tags: BizTalk | BAM | Add-In | Excel | Errors and Warnings, Causes and Solutions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s