Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2010 not using Options:Open Registry key to installAddins/Add-Ins??
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. I really do not want to have to resort to forcing the user to copy the files into the addins folder. Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set Excel 2010 as default for open excel files instead of 2 | Excel Discussion (Misc queries) | |||
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 | Excel Programming | |||
Excel 2007 cannot open Excel 2003 documents. Registry Policy Setti | Setting up and Configuration of Excel | |||
Confirm Open After Download - Reading Registry | Excel Programming | |||
Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN | Excel Programming |