I have a package which is an excel addin. It installs 7 files and related registries. In which 1 dll , and 1tlb file I have to replace. but After replacing those files addins are not coming. In the old package addins are coming. In respective components of those dll and tlb file there are other registries as well. So I am not sure which registries are usefull out of those to install excel addins.

need guidance for troubleshooting.
0 Comments   [ + ] Show 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.

Answers

0
Don't be tempted by the brain-dead scripts around which add the 'OPEN', 'OPEN1', 'OPEN2' registry entries to add add-ins. Use Excel Automation. There are sample scripts posted here on AppDeploy.

You *may*, however, need to add entries in the HKCU\Software\Microsoft\Office\<VersionNumber>\Excel\Add-in Manager, in order for the add-in to appear in Excel's list. Bizarrely, we've found that sometimes they appear without having to do that, sometimes not. I normally blame sun-spot activity, since there seems to be no other explanation.

Note also that some XLLs (as opposed to XLAs) require "registration": look up the RegisterXLL method on MSDN.
Answered 08/28/2009 by: VBScab
Red Belt

Please log in to comment
0
1) I used picture taker of working msi.
2) then I deleted old files from this msi, then i imported new files and installed it.
3) whatever things I felt missing I added everything, but still addin is not displaying
Answered 08/28/2009 by: abking99
Second Degree Blue Belt

Please log in to comment
0
as vbscab has suggested there are lots of scripts on excel add -ins on this forum
are you using active set to call your scripts

can you post your script
Answered 08/28/2009 by: cygan
Fifth Degree Brown Belt

Please log in to comment
0
I am not using any script. In source I got 1 msi, and 2 new files. These file I have to add in the msi. Which will add addins.
Answered 08/28/2009 by: abking99
Second Degree Blue Belt

Please log in to comment
1
If you want add-ins to appear in Excel, you need to use Excel Automation via a script, examples of which can be found here on AppDeploy.

I think that's made it clear.
Answered 08/28/2009 by: VBScab
Red Belt

Please log in to comment
0
[:)] Great answer!!!
Answered 08/28/2009 by: abking99
Second Degree Blue Belt

Please log in to comment
0
I had to step back from my computer 6 ft to read that. [:D]
Answered 08/28/2009 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
0
[:D] I knew somebody would find a use for those super large fonts some day! LOL...
Answered 08/28/2009 by: aogilmor
Ninth Degree Black Belt

Please log in to comment
0
ORIGINAL: turbokitty

I had to step back from my computer 6 ft to read that. [:D]


Me too, me too. LOL
Answered 08/28/2009 by: McRip
Orange Senior Belt

Please log in to comment
0
LOL could you take that in english too Ian? [:D]
Answered 08/31/2009 by: AngelD
Red Belt

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