Hello,

When excel opens, I need it to launch an XLA that in turn launches
another one. Currently I do it via setting up a reference from first to
second XLA and then using the following code in first XLA's auto_open
sub:

[XLAAddInName].launch

This works fine when launched from VBA editor. However, when launched
open Excel opening, I get the following error message:

"This workbook is currently referenced by another workbook and cannot
be closed."

Any suggestions would be highly appreciated.

Lev

If you have a reference to XLA2 in XLA1 then there is no need to open
it. It will be opened automatically - unless I'm missing something here?
I don't see why you need the [XLAAddInName].launch line therefore.

HTH

levka wrote:
Hello,

When excel opens, I need it to launch an XLA that in turn launches
another one. Currently I do it via setting up a reference from first to
second XLA and then using the following code in first XLA's auto_open
sub:

[XLAAddInName].launch

This works fine when launched from VBA editor. However, when launched
open Excel opening, I get the following error message:

"This workbook is currently referenced by another workbook and cannot
be closed."

Any suggestions would be highly appreciated.

Lev