Help with Arrays

[tarzan538]

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]

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]

just a guess but maybe the [0] and [5] are some sort of processing control?

[VBA]
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")
[/VBA]




Paul

[rbrhodes]

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]

Thank you for your help.