Accessing the Solver AddIn to Excel from LabVIEW

[karin]

I would like to be able to set the parameters and run the Solver AddIn in Excel from LabVIEW. I know that from LabVIEW you can install the different AddIn's but is there anyway to access the actual AddIn once it has been installed?

[Ben Schulte]

Hi Karin -

I believe your answer is ActiveX.
Briefly, ActiveX allows application a (e.g. LabVIEW) to control application B (e.g. Excel, Word, etc.) programmatically. The kicker is that application B must export that functionality to LabVIEW. We ship an example with LabVIEW that controls Excel via ActiveX, it will give you a head start. We do not provide extended support for ActiveX programming simply because there are literally thousands of applications we could control. Microsoft might be able to shed more light with an Excel ActiveX programmer's reference or some relted document.

good luck-
ben schulte
national instruments

[Gorka Larrea]

Perhaps having a look at VBA (Visual Basic for Applications) may help, as long as all ActiveX calls to Excel, Word ... are at least listed, when not correctly explained.