PowerFlex 700 and excel

hey everyone,

i am currently working on a project with the powerflex 700 and with RSlogix5000. however i need to do a interlocking with excel. meaning i have to be able to read and write commands from excel.

anyone with any ideas, please respond!

thanks

Bogle

http://www.plctalk.net/qanda/showthread.php?t=82918

http://www.plctalk.net/qanda/showthread.php?t=68645

Here are a couple of threads that will give you some ideas. I would not personally use Excel. I would look for something like AdvancedHMI.
https://sourceforge.net/projects/advancedhmi/

Regards,

hey Garry,

thanks for your help. however the only thing i am allowed to use is excel.
reading data is usually the easy part, as you just have to do a paste link and it reads the live values. writing data is where the problem is at.

let me know if you know anything about this.

thanks

Excel will never be control reliable. To perform writes from Excel to the DDE/OPC topic, you will need to make use of DDEPoke. You can find an example in the RSLinx help file by searching for DDEPoke. That example (like most) is bare bones. You will need to add more error checking and other bells and whistles to make it somewhat reliable. It will never bee 100% no matter how much VBA code you strap onto it.

Here is an example of a pretty robust Excel to RSLinx implementation that can give you something to build from:
http://forums.mrplc.com/index.php?/files/file/543-excel-to-plc-thru-rslinx-demo/