PAx COM add in automated enable/disable

[jgrabowski]

Hey Everyone,
I'm working on an internal project as part of an upgrade from Perspectives to PAx. Due to the large size of our user base we are looking to run Perspectives and PAx in parallel for a time via our Citrix instance without splitting Citrix servers. Ideally, when a user clicks the Citrix icon, there would be a batch script that runs behind the scenes to set their add ins appropriately for either Perspectives or PAx on Excel launch.

Has anyone tried enabling/disabling the PAx COM add in via a script or some other form of automation? The two IBM Excel add ins are easy to handle via registry, but I cannot find anything about where the COM add in can be manipulated via registry entry or otherwise. TIA for any help.

Joe

[ascheevel]

I have a batch file that users can run to restore the PAX COM add-in load behavior to load at startup if it inadvertently switches to manual (happens during an excel crash usually). Below is a powershell line that does that. Most often I've found the add-in load behavior value in that location, but it can vary.

Code: Select all

set-itemproperty -path registry::hkcu\software\microsoft\office\excel\addins\cognosoffice12.connect\ -name 'LoadBehavior' -value '3'

[jgrabowski]

This is helpful, thanks! I'll speak with my Citrix folks...Possibly can set everything to disabled by default and then run this to enable the COM add in.