Ron,
I left a message on two of your other threads, that addressed
this, but wanted to make sure you get it here too. I have also added
a couple of additional thoughts I think you will have to consider.

Ron Bovey is right about the Add-in Manager Key. You can add a reference
to your add-in there as well, but it will not be active. And this is
located in
HKEY_CURRENT_USERS, so it would have to be added during a users
session. The format of the entry in the Add-in Manager would be as follows

Name Type
\\AMachine\AShare\myaddin.xla REG_SZ

After the add-in is selected, and excel is closed the entry is moved to
the Options key.

There are several considerations you will have to think through for
this whole process, which include security considerations!

If you want the add-in installed "ready to run" you will put it directly in
the
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Options key.
Each of the current add-ins you have checked off in excel will have an OPEN
entry here. For example

Name Type Data
Open REG_SZ "C:\someplace\myaddin.xla"
Open1 REG_SZ "\\AMachine\AShare\myaddin.xla"
Open2 REG_SZ "\\AnotherMachine\AnotherShare\Myaddin.xla"

Here are several things to consider...
- What add-ins are currently assigned in this key?

- Second, if the network goes down your users will get a dialog telling
them
that the add-in could not be found. When they click the OK button,
excel continues and the add-in is not loaded.

- Third, your users will have to register the add-in, as it is placed in
HKEY_CURRENT_USER.

- Fourth, the security you have selected for Excel could get in your way.
You might have to sign the add-in to get around this. If security is on
HIGH, with trust all add-ins and templates unchecked, the add-in will
not be installed, and no error dialog will be presented to the users.

I would recommend testing on two machines in your environment. What
version of Excel will you be using, and will the users all be in the same
domain?

The first step should be testing this out in your environment.

Let me know how it turns out.


Thanks...

Stephen Culhane

Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.





--------------------
| From: "Rob Bovey"
| References:


| Subject: Excel Add-in path in UNC format
| Date: Mon, 7 Jul 2003 14:10:51 -0700
| Lines: 62
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID:
| Newsgroups: microsoft.public.excel.programming
| NNTP-Posting-Host: router.rob-bovey.com 206.63.253.33
| Path: cpmsftngxa09.phx.gbl!TK2MSFTNGP08.phx.gbl!tk2msftn gp13.phx.gbl
| Xref: cpmsftngxa09.phx.gbl microsoft.public.excel.programming:38398
| X-Tomcat-NG: microsoft.public.excel.programming
|
| Hi Ron,
|
| The only directory that Excel will look in for add-ins automatically
is
| the local Office\Library directory. All add-ins located outside this
| directory must be listed individually under the Add-in Manager registry
key
| as Stephen describes in order for them to appear on the Tools/Add-ins list
| (when they are selected from this list they are automatically moved from
the
| Add-in Manager key to one of the OpenX values under the Options registry
| key).
|
| --
| Rob Bovey, MCSE, MCSD, Excel MVP
| Application Professionals
| http://www.appspro.com/
|
| * Please post all replies to this newsgroup *
| * I delete all unsolicited e-mail responses *
|
|
| "Ron Reaugh" wrote in message
| ...
|
| "Stephen Bullen" wrote in message
| ...
| Hi Ron,
|
| And do it in UNC and not a mapped drive fashion.
|
| Addins in non-default locations are stored in the registry under the
| key:
|
| HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Ex cel\Add-in Manager
|
| where the 9.0 depends on the version of Excel:
| 8.0 Excel 97
| 9.0 Excel 2000
| 10.0 Excel XP/2002
|
| If you add a new string value in that key where the name is the full
| UNC path to the addin and the Data is an empty string, Excel should
| pick that up in the Tools Addins list.
|
| So, you could create that entry by hand on your machine, then export
| the key and import it on your users machines.
|
| Cool and thanks. Now is that "the full UNC path to the addin" possibly
| just
| a directory where any/all .xla-s therein would be recognized as add-ins
or
| must the "the full UNC path to the addin" be a full path to an
individual
| .xla only???
|
|
| Regards
|
| Stephen Bullen
| Microsoft MVP - Excel
| www.BMSLtd.co.uk
|
|
|
|
|
|