The key is to only have Excel itself load one addin (either an xla or COM
addin or Automation Addin or whatever), then that addin loads the other
ones.

An XLA addin is basically a hidden Excel workbook. You can open it like any
other workbook using Workbooks.Open without using the Excel.Addins
collection or going anywhere near the registry etc.

an automation addin is a different animal (its basically a DLL rather than a
workbook) supported only from Excel 2002 onwards, and needs to be installed
using regserver and Addins.Add.

so if the automation addin needs to be loaded first the simplest solution is
my first suggestion: do not have the XLA addin installed using Tools Addins
(ie no registry OPEN etc entries) just add some code to the automation addin
which opens the XLA addin when it needs to.

Or you could write a simple loader that installed the automation addin
(shell to regserver if needed then addins.add) and then opened the XLA, or
vice-versa.

If you want a more comprehensive example of an addin loader look at the
Automatically reversioning addin loader on my downloads page (but it only
handles XLA addins)

Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

wrote in message
oups.com...
OK,

The VBA add-in "depends" on the automation c# add-in. So the automation
add-in needs to be loaded first. Wha I was suggesting in the previous
email is that *if* the VBA add-in insists on being loaded first,
perhaps it could have some code that checks whether the automation
add-in is loaded and, if not, load it.

Also,

1. What Michel is suggesting simply does not work for me. Excel simply
rewrites the OPEN keys in the mentioned location.

2. I like the idea of a "simple loader" and I have several questions
about it.

A. Would you recommend that it is written in VBA?
B. How would I make sure that *it* is loaded first?
C. What's the command for loading an automation add-in?
D. What's the command for loading a VBA add-in?

Michel Pierron wrote:
Hi,
Change order of the OPEN keys in
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\Options
10.0 is version of excel2002
Regards,
MP

a écrit dans le message de
ups.com...
Hi,

We have an automation add-in and a VBA add-in that depends on the
automation add-in and we just can't get the automation add-in to
load
before the VBA add-in!!!

We've tried just about anyithing. Unloading them and loading them
back
in (every time restarting Excel). Going to the registry, deleting
the
OPEN* variables and then uploading the add-ins in the same correct
order again. Nothing works: they just switch back!!!

Is there a way to fix this problem? We are very desperate so any
help
is appreciated!

Many thanks in advance!!!

Aaron Fude