excel add-ins

[flai]

I've got a problem with the add-in function for excel. I'm able to open an excel workbook thru ActiveX and transfer data into the worksheets. However, I'm not able to view my DPlot add-in. The add-in box for DPlot is enabled in the Tools->Add-ins... If I disable that, go OK, then go back into Tools->Add-ins... again to re-enable the DPlot box, it's available.

If I run excel the normal way (ie not thru Labview), my add-in is visible straight away.

Does Labview disable some add-ins? Is there a way to keep the add-ins always enabled and available?

I'm using Labview 7 and Excel 2003.

[CarlaU]

Hi flai,

LabVIEW does not disable any add-ons from Microsoft Excel. Can you explain a bit more about what LabVIEW is actually doing and what you expect it to do? Maybe you could post a screenshot of the block diagram so that we can see how you have things setup. Also, there is another discussion forum post with a similar issue that has some links to other resources as well.

[flai]

Hi CarlaU,

I have written a vi to update/transfer data from table format into an excel spreadsheet when the vi is run.

If I run Excel on its own (Not via Labview), the add-in command DPlot appears in the top Toolbar section. 

When Excel is opened up by this vi, the add-ins that have been installed (and running properly) cannot be seen on the toolbar.

However if I run the following macro in the vi  (as shown in the vi diagram above) :

    Sub add_in()

       AddIns("DPlot Interface").Installed = True

    End Sub

in the beginning of the vi to 'enable' the add-in and then when i want to quit, I run the next macro :

    Sub add_out()

       AddIns("DPlot Interface").Installed = False

    End Sub

at the end of the same vi, everything works perfectly. I thought that opening Excel via Labview should automatically run all add-ins that have already been installed into Excel previously. Is there a way to have the add-in command always there without the hassle of turning it on and off? Cheers!

[CarlaU]

Hi flai,

Thanks for the information. Have you tried to implement the property nodes and methods for AddIns?  There is an object AddIn in the property node of "_Excel.Application" and you can invoke a method "Add Excel.AddIns", which has a file name as an input. Maybe trying to implement these into your code can help bring up the Add-ons in excel at startup. I hope that helps a bit!

[luc]

I had the same problem with an add-in that was called upon opening a workbook.

I could solve it by after opening excel, call the addin property of the application, take a reference to the add-in that was needed (using its name) and then by setting the "Installed" property of the add-in first OF and then ON! It did not work just setting it on, it had to be set off first!

In the attachement there is a (non working) via wich shows the code I inserted in the "New Report" vi from the Office toolkit addon of LabView.

I am usingLabView 8.5 and excel 2003 SP3