Visual Basic For Application is not installed

by ·0 Comments

Product:

Cognos Controller 10.1.1

Windows 2008 R2 Server

Office 2010 excel

Citrix Server

Symptom:

When you start excel from inside Cognos Controller you get error message.

The error is before Excel is started on the Citrix server, as you can see in Citrix Program Neighborhood Connection Center.

Error message:

The Excel-link is not installed.

Cause:

Visual Basic For Application is not installed or deactivate on the Citrix server.

Cognos Controller Excel add in demands that Visual Basic For Applications is enabled.

Solution:

Login to Citrix server as Local Administrator

Go to Control panel

Go to programs and features

Right-Click on Microsoft Office 2010 and select change

Select Add/remove features

Check that Visual Basic for Applications is installed.

 

If you start Excel and check if the controller link is installed, if the VBA support is disabled then the controller link is shown as controllerXL.xll inside excel add-in dialog, under File menu – Excel Options. If VBA support is enabled then it will show “IBM Cognos Controller Link” inside excel add-in dialog.

 

When you are inside Excel, press ALT+F11 to active the Visual Basic editor. If this does not work, then the VBA support is disabled in your excel installation. Cognos Controller excel link demands that the VBA support is working in excel before Cognos Controller can work.

 

There can be a group policy that have deactivate the VBA support in Microsoft Office.

On the citrix server;

Go to start menu

Go to RUN

Enter REGEDIT

Click OK

Expand tree to [HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common]

If the value for vbaoff is 1 , then Visual Basic for Applications is disabled in Excel 2010.

Change the value to 0 (zero)

Exit REGEDIT

Test the Cognos Contoller Excel link again.

If you do not find the GPO that set the value, you can add below text to a file named vbaon.reg and include the file in a login script on the Citrix server to set it on the user profile.

 

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Common]

“vbaoff”=dword:00000000