Re: Order of Excel Add-ins.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Charles Williams (Charles_at_DecisionModels.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 14:36:00 -0000

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

<aaronfude@gmail.com> wrote in message
news:1109259418.984898.144350@l41g2000cwc.googlegroups.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\Excel\Options
> 10.0 is version of excel2002
> Regards,
> MP
>
> <aaronfude@gmail.com> a écrit dans le message de
> news:1109198134.920714.66940@o13g2000cwo.googlegroups.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
> >

Relevant Pages

  • Re: cleaning up Windows DLL (made with VB6)
    ... The method you referred to works fine with an ActiveX dll (working with VBA ... Automation Addin functions will be double listed ... a new session of Excel. ...
    (microsoft.public.vb.general.discussion)
  • Re: Order of Excel Add-ins.
    ... The code looks to see if the addin is in the list, and if it is not in the ... So the code should work regardless of the state of the automation addin ... my c# add-in does not know that the VBA add-in exists. ... If my automation add-in is clicked to be> loaded when Excel starts, but my VBA add-in with your wonderful code> beats Excel to the punch, will Excel try to load it afterwards anyway> and if so will it cause an error? ...
    (microsoft.public.excel.programming)
  • RE: Update of UDF (User Defined Function)
    ... I have not tried using Volatile in a COM addin. ... "Jim Thomlinson" wrote: ... I'm developing a COM Addin and an Automation Addin for Excel XP and 2003. ... The COM Addin is loaded at startup and it checks that the Automation Addin ...
    (microsoft.public.excel.programming)
  • Problem deploying an automation addin (VS2005, Windows XP SP1, Excel XP)
    ... I have made an automation addin which is working on the computer ... then made a batch script that would copy and install it on another ... because our company won't deploy SP2 on our computers (updating to SP2 ...
    (microsoft.public.excel.programming)
  • VS2005 Shared Addin wizard requires XP SP1 ?
    ... I have made an automation addin which is working on the computer ... then made a batch script that would copy and install it on another ... because our company won't deploy SP2 on our computers (updating to SP2 ...
    (microsoft.public.vsnet.general)