Excel Add-in and Citrix Client/Server

[Oisin O'Reilly]

Hi,
I've posted this on a Citrix site with no response - this question is
to do with the interaction between Excel and Citrix.

I am not a Citrix guru, however a customer of ours is using Citrix,
and is using our application (an Excel .XLA addin). They use Excel
from the client by connecting through Citrix to the Server. The
problem occurs when they try to install our Add-In. The VBA which
installs our toolbar and menu does not work, for example the below
"Add" call fails. Are there restrictions in what VBA can do when
connecting to a Citrix server? Is there a way to make a VBA add-in
Citrix Enabled? Is it getting confused and trying to access
commandbars on the wrong system? etc..etc.. - Any help would be
greatfully appreciated!
Thanks Oisin

' Find view menu
Dim ViewMenu As CommandBarControl
Set ViewMenu = Application.CommandBars(1).FindControl(ID:=30004)

' Menu bar doesn't exist currently, now add it.
Set newMenuBar = Application.CommandBars(1).Controls. _
Add(Type:=msoControlPopup, before:=ViewMenu.Index)

 

[Anthony]

Hi Oisin,

What is the error message when the Add call fails? This may help
determine your problem. Can you debug the code within the Citrix
session?

I have a similar issue with Outlook. My Outlook COM addin works well
when run in a Windows environment but has issues when run within a
Citrix session. In my case the buttons are added (even the tooltips) but
have no images (they are custom images pasted from the clipboard using
the commandbarcontrol method, PastFace).

I posted a request under this title "Citrix/Outlook COM Add-in PasteFace
button issues" but nobody seems to have had any issues with customised
Office products in Citrix. I have found very little information about
this and I see no-one has responded to your inquiry either.

Sorry I could not have been more help.

Regards,
Anthony