/build/static/layout/Breadcrumb_cap_w.png

Excel Add In Deployment - Please Help!

Hi,

I have a question in regards to an Excel add in deployment issue. Basically I've packaged a financial application called Holt Valuesearch. One of the requirements is to load an excel add-in into excel that runs from a network share, the add-in should be loaded after the application has installed. I've created a custom action to load the add-in (I got the code from here!). When I run the MSI in UI mode it works fine, but my problems are encountered when I deploy the MSI as a user based deployment via Active Directory, basically my add-in doesn't load. Below is the custom action and sequence, can anybody shed any light on why it's not working?

Custom Action:

On Error Resume Next
Dim oXL
Dim oAddin
Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("\\Mandg.co.uk\dfs\APPS_UAT.MG1\Holt Linker\VS7Linker_DM.xla", False)
oAddin.Installed = True
oXL.Quit
Set oAddin = Nothing
Set oXL = Nothing

Return Processing: Synchronous (Check exit code)
In-Script Execution: Immediate Execution
Install Exec Sequence: After InstallFinalize
Install Exec Condition: Not Installed

0 Comments   [ + ] Show comments

Answers (2)

Posted by: anonymous_9363 15 years ago
Red Belt
0
Looking at the CA's entry in the 'Custom Action', what is the value in the 'Type' column? I'm willing to bet it's '806'...
Posted by: cowley 15 years ago
Orange Belt
0
Hi VBSCab,

It's a Type 38. Bizarrely it's started working now, honestly I tried it with numerous actions yesterday and it wouldn't play ball, have since tried it a few times this morning and it's A OK!
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ