Writing to Open Excel file

[ASharma]

At one time I was told of a 3 or 4 letter acronym (not ActiveX or anything like that) for a technology which allowed writing to an open Excel document.  I searched for that acronym on Discussion Forums and found an example which perfectly addressed the problem I was having.

Unfortunately I can't find that example anymore and I don't remember what that acronym was!  Any ideas?

[PJS]

As long as the file is not locked you can write to it using either the report generation toolkit for ms office (labview add-on) or using the ADO interface (sql) using the database toolkit or other ado db tools written that are available for labview.  Search the forums.

[Michael_Munroe]

Try searching for DDE.  It was the best way to remotely control Excel until about 12 years ago.

[Amanda_H]

Hi 2and4,

Yes, I believe that DDE is the protocol you are interested in. While I do not know the exact forum post you found, try glancing at these previous posts:

Need help in DDE communications with Excel

retrieving data from excel using DDE

Let me know if this helps!

Regards  

[ASharma]

Thanks to all!  DDE was it...