LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

closing the excel file opened by system exec.vi for writing data using dde

hi
i use open dde to write data to particular cells of excel and i update the data in those cells every 1sec.now to do that i open the excel first using system exec.vi. when i stop the labview i want to close the excel. is there anyway to accomplish it
thanks
0 Kudos
Message 1 of 3
(2,867 Views)
A more modern way of interfacing to Excel is via ActiveX controls. Select Help > Find Examples > then Search for Excel. There are many example for interfacing with Excel.

You can also search this forum for "ActiveX Excel" and you'll find numerous discussions about the topic

Tim
0 Kudos
Message 2 of 3
(2,867 Views)
Download the Open G Toolkit from www.openg.org. There is a VI called Quit Application.vi that works great. I have used it with the very stupid Brooks 0154 SmartDDE Controller program to reset the application.

Be sure to save the document and close the DDE communication first.

Michael
www.abcdefirm.com
Michael Munroe, CLD, CTD, MCP
Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.1, now with a new Interactive Window Manager!
Now supports full project automation using one-click custom macros or CLI.
0 Kudos
Message 3 of 3
(2,867 Views)