If you want to know whether an XLA file has been opened either by the addin
manager or some other means use

Dim oAdd as workbook
set oAdd=nothing
on error resume next
set oadd=workbooks("Myaddin.XLA")
on error goto 0
if oadd is nothing then msgbox "Myaddin.xla not loaded"

If you want to know what references are to the XLA are valid in the VBE you
need to add a reference to the VBA extensibility library and look at the
references property of your project

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"Isabelle Robin" wrote in message
...
Hi to all,

I search how to know if an a reference to a xla file is active, in a xls
file.

Do you have some advice ?

thks a lot