Anthony Berglas has brought this to us :
On Jul 5, 2:49*am, GS wrote:
Anthony Berglas formulated on Sunday :
Hello All,
The way add-ins are installed seems to have changed radically from the
Beta to the final release of Excel 2010.
I have an ordinary VBA Add In, and have for many version of Excel used
a simple installer that sets
* HKCU\software\microsoft\office\14.0\excel\Options: OPENn
to the .xlam file that is the add in. *(If more than one add-in is
installed then the keys are listed as OPEN1, OPEN2...) *The .xlam file
itslef is stored by default in an arbitrary folder, not an addins
folder.
This worked in the beta.
But in the production version, setting this key makes no difference.
I can install the add-in perfectly via the UI, but then a full search
of the registry fails to find any key that points to the add-in.
Moving the add-in files causes Excel to complain, so something is
definitely pointing to them.
(I have tried to use Sysinternals Procmon, but Excel does so much that
it will take time to filter the results. *100s of events per second
when Excel is just sitting there! *During an add in install it opens
the add in file dozens of times.)
Any ideas as to what happened would be greatly appreciated. *Many
people will have this problem.
A work around is to install the files in the %APPDATA%\Microsoft
\AddIns folder. *Make the .xlam the top level. * (In my case I also
have a .xla file for older versions of Excel, but that must *not* be
in the AddIns folder or XL 2010 prefers it over the .xlam and
complains.) *Then the addin appears in the list, but still needs to be
manually enabled. *The add ins list is hard for some users to find,
being four clicks from the top.
Anthony
Try...
Add the addin to the 'Add-in Manager' key during install, so Excel
treats it as a member of the Addins collection. Then, if you wish it to
be 'installed' at runtime, add it to the 'Options' key.
--
Garry
Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -
- Show quoted text -
Thanks for that. However, in pre XL 2010 the HKEY_CURRENT_USER
\Software\Microsoft\Office\12.0\Excel\Add-in Manager key seems to
simply store the add in name while it is unchecked and thus removed
from the Options:OPENn list. Enabling the add-in seems to move it
back to the Options:OPENn key. It never appears to be in both places
at once.
The value of the Add-in Manager key always seems to be binary 0 (if
present). I have not found any useful documentation.
Have you actually had any success with this on Excel 2010? (Previous
versions work fine.)
Regards,
Anthony
Oops! Need to correct my previous post. I looked at an old addin
install script and realize that it only writes the Options key. Sorry
to throw confusion at you!
I can't confirm how it works in MSO 2010 because I don't have it
installed yet. Meanwhile, I've emailed Rob to see if he's encountered
any v2010 behavior anomolies with our script. I'll post back when I
know more.
Again, I apologize for my previous assumptions regarding the Add-in
Manager key.
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc