Excel data logging

[chilau 0]

Hi I am trying to log 6 data registers in a Allen Bradley SLC500 PLC, I have managed to set up the DDE links etc in excel but was wondering if anyone has a example macro that would allow each registers value to be updated in a new cell every 1 second Thanks

[BobLfoot 302]

Check the download section. I know there are a couple of examples there.

[sathya 1]

hi i don think it will work in SLC500, u can store all value in plc n paste link in excel n show sum of 254 values

[BobLfoot 302]

What you describe can be done in CLGX, PLC5 and SLC500 . The spreadsheet found in this download http://forums.mrplc.com/index.php?autocom=downloads&showfile=543 is modifable to do what you want.