Folks,
I have a excel linking question that I have not been able to solve or find an answer to via googling.
I want to assign a spreadsheet cell with a formula like so:
=RSLINX|CLXPLC!'tagname[excel cell reference].property'
where: -tagname is an CLX DINT array like "tagname[100]".
-excel cell reference is a cell like "C2" or "D1"
-.property is a property tag of type DINT (for this example)
The Problem is the reference 'excel cell reference'. If I plug a number into the array, like [92], no problem and the PLC data is retrieved. But if I try to use a cell reference from within the spreadsheet, it doesn't work. My array number is in cell C2 so I've tried using !C2, 'C2', #C2 etc etc but always get a #NAME error.
Does anyone know how this is done?
I have a feeling I need to cocantenate a string of the formula I want, first...
Tanks!
I have a excel linking question that I have not been able to solve or find an answer to via googling.
I want to assign a spreadsheet cell with a formula like so:
=RSLINX|CLXPLC!'tagname[excel cell reference].property'
where: -tagname is an CLX DINT array like "tagname[100]".
-excel cell reference is a cell like "C2" or "D1"
-.property is a property tag of type DINT (for this example)
The Problem is the reference 'excel cell reference'. If I plug a number into the array, like [92], no problem and the PLC data is retrieved. But if I try to use a cell reference from within the spreadsheet, it doesn't work. My array number is in cell C2 so I've tried using !C2, 'C2', #C2 etc etc but always get a #NAME error.
Does anyone know how this is done?
I have a feeling I need to cocantenate a string of the formula I want, first...Tanks!
