Hi All,

This is a very simple thing I need to do. I have been given a .XLA file named Test.XLA . I need to copy it to a location (C:\ProgramData\Test). I am using Vista 32-bit and Office 2007. The Add-in should load when Excel is started. For this I included an OPEN key in the registry HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options, pointing to the path of the .XLA file i.e. C:\ProgramData\Test\Test.XLA

However when you launch Excel it does not load. You have to go and manually make it load from Excel Options-> Add-ins.

Any info on why this Add-in is not loading by itself?
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity

Answers

0
A search on AppDeploy (sigh...) would have revealed many posts on this subject.

Adding an 'Open' entry to the registry is a bad idea. If the user already had one there, your package will overwrite it. That's not a good way to impress users. That same search would have produced either links to a script or the script itself which uses the Excel.Application object model to do this job.
Answered 05/26/2009 by: VBScab
Red Belt

Please log in to comment
0
I know about the OPEN key, and I am taking the usual steps to handle it. But my question was that inspite of the OPEN/OPEN1 key present the Add-in does not load itself.....I will do a search again..

Thanks for the response.
Answered 05/26/2009 by: ghosh.kunal
Senior Yellow Belt

Please log in to comment
0
I did get a lot of scripts which use the Excel.Application model and I tried a few but they did not work. I tried this sample script :

On Error Resume Next
Dim oXL
Dim oAddin
Set oXL = CreateObject("Excel.Application")
oXL.Workbooks.Add
Set oAddin = oXL.AddIns.Add("C:\ProgramData\Test\Test.xla", True)
oAddin.Installed = True
oXL.Quit
Set oAddin = Nothing
Set oXL = Nothing
Answered 05/26/2009 by: ghosh.kunal
Senior Yellow Belt

Please log in to comment