Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to set Excel 2010 as default for open excel files instead of 2 Steven Excel Discussion (Misc queries) 2 April 22nd 23 02:08 AM
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3 Darrell[_2_] Excel Programming 0 January 12th 10 08:53 PM
Excel 2007 cannot open Excel 2003 documents. Registry Policy Setti Gordon Gecko Setting up and Configuration of Excel 0 March 4th 09 02:19 AM
Confirm Open After Download - Reading Registry Tim Childs[_6_] Excel Programming 3 November 30th 03 05:31 PM
Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN rsbitian Excel Programming 0 October 22nd 03 06:11 AM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"