ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Control LabView Executable Via Excel

Hello Everyone,

 

 I am trying to use  Excel to control a LabView executable ( send in data, get out data).

When browsing the net, I found exactly the thing that does it. Unfortunately I am too stupid to get how it works.

Here is the code that I found: http://forums.ni.com/ni/board/message?board.id=170&message.id=127040&query.id=268934#M127040

 

 The attached vba-code is this:

 

Private Sub Workbook_Open()
    Dim lvapp As MyLabVIEWServer.Application
    Dim vi As MyLabVIEWServer.VirtualInstrument
    Dim paramNames(1), paramVals(1)

    Set lvapp = CreateObject("MyLabVIEWServer.Application")
   
    Set vi = lvapp.GetVIReference("MyData.vi", "", True)
   
    Sheet1.Cells(1, 1) = vi.GetControlValue("Number")
   
    lvapp.Quit
End Sub

 

When issuing 'set lvapp = CreateObject(:::::)' the server.exe pops up.

But how does it know in the first place:

a) where to look

b) what to open, since the name isn't mentioned

                          

Thanks for any hints on this 

 

RandomWireMan

0 Kudos
Message 1 of 1
(3,061 Views)