Jump to content


This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
Photo

How to delete Excell addin from each user account


2 replies to this topic

krulik

krulik
  • Full Members
  • 2 posts

Posted 20 September 2007 - 10:19

Hi.
I have the next problem. During installation Add-in for MS Excell is registred via VBS script:
CODE

Dim oXL, oAddin, sPathToXLA
Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add
sPathToXLA = Session.Property("CustomActionData")
Set oAddin = oXL.AddIns.Add(sPathToXLA, True)
[COLOR=red]oAddin.Installed = true[/COLOR]
oXL.Quit
Set oXL = Nothing


To delete addin I've made Custom Action with the same code as mentioned above But property
CODE
Installed
is setted to
CODE
False
. It should remove the add-in.
But this CA removes addin only for current user! When Excell is launched under some another user, dialog with error message is appears: ""c:\Program Files\SomeAddin.xla could not be found".

The reason of this error: value (it contains full path to addin file) under "HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options" registry key in each user account.
Can somebody tell me how can I solve this problem

PS: sorry for my bad english unsure.gif

Edited by krulik, 20 September 2007 - 11:14.


krulik

krulik
  • Full Members
  • 2 posts

Posted 21 September 2007 - 10:11

i solve this problem via Active Setup and VBS file.

IN pkg added Custom Action with condition
CODE
REMOVE="ALL"

This CA will call reg.exe:

CODE
reg.exe ADD "HKLM\SOFTWARE\Microsoft\Active Setup\Installed Components\{585DB6F1-4072-4BC7-BFC1-575D4F95DFC0}" /v StubPath /t REG_SZ /d "cscript [SystemFolder]RemoveExcellAddin.vbs [AddinFileName]" /f


Component with RemoveExcellAddin.vbs file marked as msidbComponentAttributesPermanent
This script will:
- detect current version of MS Office;
- search required OPEN value in "HKCU\Software\Microsoft\Office\OfficeVersion\Excel\Options". And del this value.

Attached Files


Edited by krulik, 21 September 2007 - 10:30.


Big_bird

Big_bird
  • Full Members
  • 1 posts

Posted 31 January 2008 - 17:52

Thank you krulik, I met this probrem too. And I will try to do like your solution.