Excel Macro to start for every user starts excel on Citrix Server

[Zep042]

I have an excel macro that enables the addin for Analysis Tool Pak (it is already installed on the server). I'm trying to get this to run for every user that opens excel on the citrix server.

In my xls or xlt file I have created the Autpen macro that works when I open the file file by double clicking on it, but the XLStart and (Excel) Startup folders are not working.

Does anyone have any suggestions?

My ultimate goal is to have the Analysis Tool Pack Enabled for all users.

 

[lenze]

Hi and welcome to the Board!!!
What code are you using and what is the path to the add-in?? Is it NOT on each machine?
lenze

 

[Zep042]

Sub Autpen()

' AnalysisToolPak Macro
' Macro recorded 2/18/2010

AddIns("Analysis ToolPak").Installed = True
AddIns("Analysis ToolPak - VBA").Installed = True

End Sub

The path is the standard path for the Analysis Tool Pak, except the it's Q: instead of C:.
"Q:\Program Files\Microsoft Office\OFFICE11\Library\Analysis"
Analys32.xll - Analysis Tool Pak
atpvbaen.xla - Analysis Tool Pak- VBA