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.