Knowledgebase
Statement Converter > Statement Converter Support > Knowledgebase

Search help:


Error: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.

Solution

How to resolve error message:  "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features."

This error is because "Visual Basic for Applications" is not installed.  During the installation of MS Office, it is installed by default unless the user unchecks the option.  VBA is needed to run macros and add-ins such as Statement Converter.

Solution:

Add this feature to Microsoft Office:

1. If Excel is open, close it.

2. In the Windows Control Panel, choose "Add or Remove Programs" (or Programs and Features in Windows Vista or Windows 7).

3. Select Microsoft Office in the list and click on the Change button.

4. Choose "Add or Remove Features"

Excel Add or Remove Features

5. Select "Visual Basic for Applications" in the "Office Shared Features" list and set it to "Run from My Computer".  Click Continue.

Excel Installation Options

6. After the installation is finished, start Excel and you will be able to use Statement Converter.

 
Was this article helpful? yes / no
Related articles If it doesn't run (Excel 2007, 2010, 2013, 2016)...
Installing with Excel 2016, 2013, 2010, 2007
Error: "Macro may not be available or all macros be disabled"
Article details
Article ID: 61
Category: Installing / Uninstalling the program
Rating (Votes): Article rated 3.1/5.0 (30)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies