Hi all,

I have a problem with an Excel document that I inherited at work, and
which -sadly enough- is important to QA.
I have narrowed down the problem to the following repro case

There is an add-in called DeltaV.xla which has a number of public methods
that are used to retrieve data from a live system through a COM component.
This add-in is registered under tools-add-ins.
I do the following to use it:
1) I open excel via the start menu. the add-in gets loaded
2) I click on the add-in specific toolbar button that allows me to configure
a field so that it receives a single data value from the system. This
results in cell A1 having the contents '=DvRead("tagname")' (minus the
single quotes of course).
3) after 3 to 5 seconds the data appears, though I have to press F9 to
refresh it.
4) I save the workbook and close excel.
5) I open the workbook by doubleclicking and the following happens

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 the 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"

It seems as if the add-in is not loaded if I open the document by clicking
on it in the windows explorer. I have switched to VBA mode and verified that
indeed, the add-in is not loaded. After some googling I have the impression
that this is normal, but I am not sure.

I did some research this afternoon, and the solution seems to be that I have
to load this add-in myself and open activate it in my workbook_open handler,
but I have no idea on how to do this, or if this is everything I need to do.

I am a complete VBA newbie so I was hoping that someone could explain me in
detail what I have to do.

Kind regards,
Bruno van Dooren MVP - VC++

http://msmvps/com/blogs/vanDooren