PDA

View Full Version : Help with Arrays



tarzan538
05-11-2010, 12:40 PM
I have a worksheet where I take a group of cells (column GG) and via a button I send these values to a PLC (programable logic controller). I do not understand why it won't allow me to send more that 5 rows. If instead of L5 I put L6 then value # 6 won't go through.

Existing and fucntional array:

DDEPoke RSIchan, "CIP1.StringArray7[0],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[5],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG14:GG18")
DDEPoke RSIchan, "CIP1.StringArray7[10],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[15],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[20],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[25],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[30],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[35],L5", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")

Aussiebear
05-11-2010, 02:45 PM
Not enough information provided, can you tell us what is the code that sends these arrays, and what's the difference between L5 & L6

Paul_Hossler
05-11-2010, 05:49 PM
just a guess but maybe the [0] and [5] are some sort of processing control?


DDEPoke RSIchan, "CIP1.StringArray7[0],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[6],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG14:GG18")
DDEPoke RSIchan, "CIP1.StringArray7[12],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[18],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[24],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[30],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[36],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")
DDEPoke RSIchan, "CIP1.StringArray7[42],L6", Worksheets("CIP1 (Main Sequencer)").Range("GG9:GG13")



:dunno :dunno :dunno

Paul

rbrhodes
05-11-2010, 05:53 PM
Some limit in the PLC I imagine:

"<Snip> I opened the RSLinx Event Log and DDE Client Diagnostics to watch what was happening during the code running. It showed me that I am limited to 115 Maximum Data Points so the 800 I was trying to do at once will not be possible. <Snip>"


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

tarzan538
05-12-2010, 05:50 AM
Thank you for your help.