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

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

Post by gottipat » Sun, 03 Aug 2003 08:53:28


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
 
 
 

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

Post by Shan » Sun, 03 Aug 2003 22:04:21

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

 
 
 

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

Post by Michael Mu » Mon, 04 Aug 2003 04:30:32

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