It seems as if the add-in is not loaded if I open the document by clicking
on it in the windows explorer.
I don't have your add-in of course, but if I select an add-in from Tools,
Add-ins such as the Analysis Toolpak or a custom one of my own, it does load
when Excel is closed and I double-click a file. That's not true for you?
--
Jim
"Bruno van Dooren [MVP - VC++]" wrote
in message ...
| 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
|
|
|
|