Add-in does not autoload on programmatic opening

[Vadim Rapp]

Hello,

I created an add-in and put it on a network share, and specified it in
add-ins. Then I used a formula provided by the add-in in the workbook.

When I reopen the workbook in Excel 2002, it works fine.

But if I open the same workbook programmatically (which is the intended
purpose), i.e. by

set ea=createobject("excel.application")
set ed=ea.workbooks.add("...\Credit Card Order.xlt")

Excel shows a dialog: "This workbook contains links to other sources. To
update all linked information, click Yes; to keep the existing information,
click No".

If I click "yes", Excel shows error message: "this workbook contains one or
more links that cannot be resolved". If I "edit links", the status of the
link is "error: undefined or non-rectangular name". If at this point I "open
source", the problem gets fixed. If not, the workbook opens up with #NAME?
in the cells using the link; however, if at this point I open tools/add-ins,
I see that my add-in _is_ checked. If I UNcheck it, the cells immediately
get fixed, i.e. the link begins to work

If I initially have the add-in UNchecked, and open the workbook
programmatically, the same sequence happens; I open add-ins menu, check my
add-in, and then it works.

Is there a way to have the add-in automatically loaded without prompts or
errors upon the programmatic startup, same as it does on manual startup?


thanks,

Vadim Rapp
Polyscience, Inc.

 

[Tom Ogilvy]

When excel is started programmatically, addins are not loaded. If this is
what you are doing, then you could open excel, load the addin, then open the
workbook.

You can load the addin by opening it, just like the workbook.