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
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)
Please log in to answer
Posted by:
anonymous_9363
14 years ago
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
14 years ago
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!
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.