Excel Add in not loading while starting Excel 2007
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?
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
Answers (3)
Please log in to answer
Posted by:
anonymous_9363
14 years ago
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.
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.
Posted by:
ghosh.kunal
14 years ago
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.
Thanks for the response.
Posted by:
ghosh.kunal
14 years ago
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
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
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.