Addin opened but not loaded
 

Hi everyone,

When I open an addin (right-clic on its name | Open), the addin is opened
and I can see the code in VBE. But the Addin is not "installed". In VBE, I
cannot "close" it so that its name disappears from the VB environment. To do
that, I have to close Excel and reopen it which is not very convenient.

The problem is that I have many versions of a particular addin (in different
folders) which I have to modify. but I cannot open another addin with the
same name as one that is already loaded.

I know how to list the addins that are installed but is there a way to list
the addins that are listed in VBE? Also, is there a way to close such an
addin without closing Excel?

Thank you.
--
Jac Tremblay

Addin opened but not loaded
 

I believe by installed, you are refering to the the list in Tools=Addins.
If you opened it, then it is as usable as any of the installed addins. To
close it, in the immediate window of the VBE

Workbooks("MyAddin.xla").Close True

would be one way.
--
Regards,
Tom Ogilvy

"Jac Tremblay" wrote in message
...
Hi everyone,

When I open an addin (right-clic on its name | Open), the addin is opened
and I can see the code in VBE. But the Addin is not "installed". In VBE, I
cannot "close" it so that its name disappears from the VB environment. To
do
that, I have to close Excel and reopen it which is not very convenient.

The problem is that I have many versions of a particular addin (in
different
folders) which I have to modify. but I cannot open another addin with the
same name as one that is already loaded.

I know how to list the addins that are installed but is there a way to
list
the addins that are listed in VBE? Also, is there a way to close such an
addin without closing Excel?

Thank you.
--
Jac Tremblay