I am using a Excel OPC Client Application and able to log only to 100 cells

Coachman

Member
Join Date
Sep 2006
Location
Maryland
Posts
97
I am using a Excel OPC Client Application ,and everything is going
well except I can only log to 100 vertical cells. I would like to use all 65,000 + . Is there something that I am overlooking.

I am reading tags from a CompactLogix PLC , using InGear
OPC Server for Allen Bradley networks , OPCWare XL for Excel , then
to my spreadsheet. Any Ideas?

Thanks in Advance,
 
Under your DDE/OPC in RSLinx open the Communication Events and the DDE and or OPC Client Diagnostics and watch what it tells you. I have been trying to poke data into the PLC and found it is limited to 115 Cells. You may be experiencing something similar. I do, however, collect a lot of data via DDE but only to the point of about 50 Verticle but all the way across horizontally.
 

Similar Topics

Hello, I am looking for help writing to PLC tags from Excel. I am using Factory Talk Gateway as an OPC server and Excel VBA to write out to an...
Replies
5
Views
3,101
Hey all, This is more of a question of "can I do this more efficiently" rather than how do I do this... We collected a week's work of...
Replies
4
Views
3,345
Hi I recently saw an AB/Rockwell guy using a excel spreadsheet of config data which he could read or write to a plc via opc. Anyone got an example...
Replies
6
Views
6,144
Hi, I'm just looking for a simple way to make a button in excel (via VBA I presume) to toggle a bit in RSLogix 5000. I just got FactoyTalkLinx...
Replies
9
Views
545
Good Morning , We had an equipment manufacture in last week. He always giving us a thumbdrive with the machine recipes . They are neatly in...
Replies
8
Views
2,490
Back
Top Bottom