Using:
RSLogix5000 v20
RSLinx Classic
RSLogix Emulator
FactoryTalk View 7.0
I am looking for code to move PLC tags directly into VBA variables running inside FactoryTalk View 7.0 without using FactoryTalk View 7.0 tags.
I have been looking at this link here: (http://www.plcdev.com/connecting_controllogix_excel)
I know you can move PLC tags into Excel cells. Supposedly the return type of DDERequest is a string. (https://msdn.microsoft.com/en-us/library/office/aa171949(v=office.11).aspx)
But I have not been able to set the variable realdata, from the first link, directly to a variable in either Excel or FTV 7.0. The workaround is opening an excel window in the background, putting the variable into a single cell, and then directly into a VBA variable (in any application using VBA). What I want to do is take that middle man (excel cells) out of the equation but I've run out of ideas to do so. If anyone has suggestions here I would greatly appreciate it.
RSLogix5000 v20
RSLinx Classic
RSLogix Emulator
FactoryTalk View 7.0
I am looking for code to move PLC tags directly into VBA variables running inside FactoryTalk View 7.0 without using FactoryTalk View 7.0 tags.
I have been looking at this link here: (http://www.plcdev.com/connecting_controllogix_excel)
I know you can move PLC tags into Excel cells. Supposedly the return type of DDERequest is a string. (https://msdn.microsoft.com/en-us/library/office/aa171949(v=office.11).aspx)
But I have not been able to set the variable realdata, from the first link, directly to a variable in either Excel or FTV 7.0. The workaround is opening an excel window in the background, putting the variable into a single cell, and then directly into a VBA variable (in any application using VBA). What I want to do is take that middle man (excel cells) out of the equation but I've run out of ideas to do so. If anyone has suggestions here I would greatly appreciate it.