Macro security / VBA error in sequence

Written by Ingmar Verheij on October 16th, 2009. Posted in Microsoft App-V

Today I had to solve a problem with multiple (Softgrid) sequences with the same symptom.

Situation
A business application generates documents based on Microsoft Word / Excel. These documents use Macro’s / VBA to communicate with the application and retrieve the necessary data.

During initial tests and the sequencing procedures everything works fine and no problems rise. However, in the tests on the terminal servers some “strange” occur when the documents are generated.
These problems result in error messages about macro security and the unavailability of VBA. Even when the macro security is (tempory) lowered these error messages keep on showing.
VBA error

Cause and solution
The problem is caused by the isolation of softgrid (now AppV). Because VBA is not in the sequence, and not directly called by the application (but through Word), it can’t locate the necessary resources.

The solution is to allow interaction with the local environment. This is done by adding the following lines in the OSD of the sequence:

Be carefull implementing local interaction, this could introduce application conflicts. You are disabling a part of isolation.
You can read more about local interaction at this Technet blog.

PS: Same type of problems occur when hardware is addressed from an application.

Ingmar Verheij

Ingmar Verheij

At the time Ingmar wrote this article he worked for PepperByte as a Senior Consultant (up to May 2014). His work consisted of designing, migrating and troubleshooting Microsoft and Citrix infrastructures. He was working with technologies like Microsoft RDS, user environment management and (performance) monitoring. Ingmar is User Group leader of the Dutch Citrix User Group (DuCUG). RES Software named Ingmar RES Software Valued Professional in 2014.

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Tags: , , , , , , , , ,

Leave a comment

*

Donate

%d bloggers like this: