Software Deployment

First, there is an *awesome* script for dealing with Excel add-ins available as a "sticky" in the 'Scripting' forum. Use that: you'll be glad you did.

Second, to deploy the user-based part of the package you need to either use Active Setup (documented to death here on AD and elsewhere) or create a new feature as a parent of an existing feature which contains an advertised entry-point, so that when that entry-point is accessed, the Windows Installer engine will trigger self-healing (again, documented to death here) for that feature.

Ok,

I'm using the mentioned script now and it works great for the installation
I modified it a litte bit because i need to specify 1 single xla file (it's a suite of excel addins with 1 admin addin to manage the others)

Installation is successful. Installed as administrator and the addin also get's installed for the logged on user. This is what i want.

But now i also want the addin uninstalled when i run the uninstall.
The script does not uninstall the addin because the xla is not installed anymore at that stage:

this is what the scripts logs:
ExcelAddinStatus: Add-in 'C:\Program Files (x86)\Add-ins\addinmgr.xla' is not installed, so no removal necessary.
But the button is still there.
And if all the extra addins (which are managed by this addin) are also active, then there are loads of buttons left after uninstall.

What do i do about this?
The xla file obviously isn't there anymore because it's being removed by the MSI...

the code below works (a script i already had) when executed from outside of the MSI but when running as CA (deferred execution), the log says it ran but the addin is not removed for the logged-on user.
I run it after installInitialize.


Option Explicit
Dim oXL
Dim strCBarName
Dim i
' file name of addin to remove
Dim fileName : fileName = "Addinmgr.xla"
On Error Resume Next

Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add

For i = 1 To oXL.AddIns.Count
If oXL.AddIns(i).Name = fileName Then
oXL.AddIns(i).Installed = False
End If
Next
oXL.Quit
Set oXL = Nothing



Am i missing something?

thnx

I suspect this is because SCCM installs (and uninstalls) using the System account.

Are you using Active Setup or an advertised entry-point?

Neither,

The user gets the application advertised by SCCM, it gets installed (by SYSTEM) and after the setup the user has the addin available in excel.
This happens without active setup/entry point.
So this CA must be running in user context right?
Only removal of the addin doesn't work because the xla is not present at the time the CA runs.

I also get this behaviour when i run the MSI as administrator while user X is logged on and the start the app as user X. user X has the addin available after install but removal as administrator does not remove the addin for user X.

And i don't know why the script i posted to remove the addin doesn't work. The addin should run in user context right? The CA has the same settings (in installshield) as the CA to install the addin (which works using the script from the sticky)

Active setup is not an option because the user want to use his program immediately after setup and not have to log off first. How do i create an advertised entry point for a CA that needs to run in user context? Is this possible?

thnx

OK, it sounds like you have theCA scheduled after the RemoveFile standard action. Re-position it in the sequence and re-test.