You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

Reply
 
Thread Tools Display Modes
Old June 20th, 2015, 12:20 AM   #1
Gi1gamesh
Member
United States

Gi1gamesh is offline
 
Join Date: Jun 2015
Location: Wisconsin
Posts: 1
How do I move PLC tags directly into VBA variables inside FactoryTalk View 7.0?

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/lib...ffice.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.
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
FT View SE Editing Without License Mark Cole LIVE PLC Questions And Answers 9 November 22nd, 2014 09:03 AM
FactoryTalk View SE - Setup StartDate from VBA rasen LIVE PLC Questions And Answers 0 October 20th, 2014 03:25 AM
Citect Vs WinCC - Long Doug_Adam LIVE PLC Questions And Answers 22 October 3rd, 2014 01:56 PM
indirect referencing of PLC tags in Factorytalk (V 6.0) HMI makarand LIVE PLC Questions And Answers 1 March 6th, 2012 10:32 AM
Factory Talk View Studio VBA to access HMI or PLC tags djpalaz LIVE PLC Questions And Answers 0 December 14th, 2007 08:57 AM


All times are GMT -5. The time now is 07:37 AM.


.