How to launch one XLA from another on Excel launch
 

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

How to launch one XLA from another on Excel launch
 

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