Excel add-in problem
 

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

Excel add-in problem
 

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

Excel add-in problem
 

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?

No.
If I open the workbook by clicking it in explorer or something like that,
the add-in will still be checked in the add-ins menu, but the 2 buttons that
should be on the toolbar are missing, and the function that would retrieve
the data causes the errors I mentioned in my earlier post.


Kind regards,
Bruno van Dooren MVP - VC++

http://msmvps/com/blogs/vanDooren