problems with running excel addins

[r_keller]

Hi,

I use ActiveX to store measurement data aquired from LV in an Excel spreadsheet, which works fine so far. In one of the data columns though I wanna use an Excel Addin to automatically calculate and update the values.

However, opening the Excel spreadsheet from LV does not start up the AddIn at all, though it works correctly whenever I start up Excel manually.

I realised there's an object AddIn in the property node of "_Excel.Application" and I can invoke a method "Add Excel.AddIns", which has a file name as an input. I tried to connect the AddIn-Filename *.xla to that input which results in an error message:

Error -2146827284 occurred at Exception occured in Microsoft Office Excel, Die Add-Methode des AddIns-Objektes konnte nicht ausgeführt werden

(translated: Add method of the AddIn-object could not be executed)

How do I start up the AddIn correctly? Im a newbie with AcvtiveX and grateful for any easy to understand support on that issue. Can anyone recommend me some useful literature to learn more about ActiveX?

Thanks for your help...

[daniel.riedelbauch]

Hi r_keller,

could you tell me a little bit more about your application? Which AddIn do you wanna use? What do wanna calculate?

Here is a link regarding ActiveX:
http://msdn2.microsoft.com/en-us/library/default.aspx

Go to (from the menu to the left):

Office Developement >> Microsoft Office 2003 >> Office 2003 >> VBA Language Reference >> Microsoft Excel Visual Basic Reference >> Reference >> Properties/Methods.

Maybe you wanna install the Office Help, as well.

Location of ActiveX Object Model Documentation for Microsoft Office:
http://digital.ni.com/public.nsf/allkb/29CDE4332C4E6A27862570AE006ECBF4?OpenDocument

Here is the documentation regarding AddIn from the Office Help:

*****

AddIns Property
See AlsoApplies ToExampleSpecifics
Returns an AddIns collection that represents all the add-ins listed in the Add-Ins dialog box (Tools menu). Read-only.

For information about returning a single member of a collection, see Returning an Object from a Collection.

Remarks
Using this method without an object qualifier is equivalent to Application.Addins.

Example
This example displays the status of the Analysis ToolPak add-in. Note that the string used as the index to the AddIns collection is the title of the add-in, not the add-in’s file name.

If AddIns("Analysis ToolPak").Installed = True Then
    MsgBox "Analysis ToolPak add-in is installed"
Else
    MsgBox "Analysis ToolPak add-in is not installed"
End If

*****

Is that what you wanna do?

Bye

Daniel
NIG