Simon Reid -

As I recall, it's always the case that an XLA add-in loaded using File Open
or XLSTART does not appear in the add-ins list.

An alternative (instead of XLSTART) might be to put the add-in XLA file in
(Windows Vista):

C:\ Users \ UserName \ AppData \ Roaming \ Microsoft \ AddIns folder

or in (Windows XP):

C:\ Documents and Settings \ UserName \ Application Data \ Microsoft \
AddIns folder.

- Mike
http://www.MikeMiddleton.com



"Simon Reid" wrote in message
...
Hi,

I have an addin, lets call it 'office2003addin.xla' which is loaded into
Excel on startup because it is in the %App data%\Microsoft\Excel\XLSTART
directory. The issue I have is that it conflicts with an office 2007 COM
addin that I have created which needs to call VBA procedures in another
addin, lets call it 'office2007addin.xlam'.

I am running VSTO code which calls the VBA. The aim is that before I call
any VBA code I first check that office2007addin.xlam is loaded, and if not
then I load it using Application.addins.

I also want to check that office2003addin.xla is not loaded, and if it is
to
remove it. The problem is that office2003addin.xla is not listed as an
active Addin, is not included in the Application.Addins or
Application.Workbooks collections so I have no way of removing it, but yet
if
I go to the VBA editor I can see it listed as a project, and it is loaded
since I can call functions it contains.

This is a bit of a strange situation, but we have the 2003 addin deployed
to
a lot of machines and I cannot guarantee that it will be removed when we
install the new version of office.

Has anyone seen this before, and is there any way of removing the addin,
or
at least telling if it is there (short of removing the file from the PC,
which I cannot do).