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   [ + ] Show 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.


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
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
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")
Set oAddin = oXL.AddIns.Add("C:\ProgramData\Test\Test.xla", True)
oAddin.Installed = True
Set oAddin = Nothing
Set oXL = Nothing
Answered 05/26/2009 by: ghosh.kunal
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity