How can I control my VI using Excel?

[Julro]

I will a my project should act as a real time. But after I finnished this I'm not the one who will use this project, this is for someone who need this VI. The Problem is, he don't want to go/change the data inside the VI because he is not oriented in LabView so that's why he want to use excel to change data inside the VI.

My VI is producing sound using MIDI, I already assigned different tones in different indicator.
the PROBLEM is, how can I change, for example, TONE
insie my VI using excel?
(would you mind if i'll ask for an example, if you have)
Thank You

julro

[Dennis_Knutson]

I'm not sure exactly what you need to accomplish. If you want to actually control and run LabVIEW from Excel, I think the only way to do that is with writing a VBA macro and calling the LabVIEW ActiveX properties and methods. I couldn't find an example with VBA but maybe this Visual Basic example here can give you some ideas. If, on the other hand, all you want to do is change some values that a LabVIEW program is using, the easiest way is to make those values changeable on the front panel of your VI or make your VI read the Excel spreadsheet. Reading an Excel spreadsheet can be done with Excel's ActiveX properties
and methods or treating the spreadsheet as a database and using ADO. One ActiveX example can be found here. If the Excel spreadsheet is saved as a text file with comma or tab delimited data, then you can use the Read From Spreadsheet function in LabVIEW. There have numerous examples and discussions on reading Excel files posted to this forum. if you do a search, you'll find a wealth of information.