From 04:00 PM CDT – 08:00 PM CDT (09:00 PM UTC – 01:00 AM UTC) Tuesday, April 16, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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?
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.
Try searching for DDE. It was the best way to remotely control Excel until about 12 years ago.
Michael Munroe, CLD, CTD, MCP Automate 1M+ VI Search, Sort and Edit operations with Property Inspector 5.0, now with a new Interactive Window Manager! Now supports full project automation using one-click custom macros or CLI.
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:
