View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
levka levka is offline
external usenet poster
 
Posts: 1
Default 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