VBA Report Using ABBGetOPCDA

Good afternoon , Could you support in the folloiwng question ?

We are performing a report tests, at the beginning we run a test using PPA Values from excel to get the values , and we wrote the path , after that because we need to delete some rows according to the result of the some values , we need to read the values from the excel cells , to do some procedures , because of the PPA values gotten in each cells , when we select the cells ( internally when we see upper) , it shows the path used ( no the values eventhough the cells shows the values) .

We run from VBA some simple commands from VBA ( in ABBGetOPCDA we used the same that we used when we run PPA Values,) please see the code it is simple , it shows an error in line ABBGetOPCDA,

Sub Test_Report()

Worksheets("sheet1").Select

Range("A2").Select

Range("A2").Value =Application.Run("abbdatadirect.xla!ABBGetOPCDA"("[Control Structure][Control Structure]Root/Control Network/CURSOTEST/Controllers/Controller_1/Hardware/0/11/1:
3.Forced",FALSE)

End Sub

the result would show if channel 3 is forced or not in S800IO 1 , and does not show timestamp

Thanks for your support

Best Regards


By ATP on 1/10/2018 | Like (0) | Report

is your problem solved?


Add New Comment


RAMA2   

asked 12 days ago



Answers

0

Hi,

You can modify the code as below. It will work. But you will not get the time stamp for the value. Only you will get the value of the particular varibale.

Sub Test_Report()

ThisWorkbook.Sheets("Sheet1").Cells(2, 2).Formula = "=ABBGetOPCDA"(""[Control Structure][Control Structure]Root/Control Network/CURSOTEST/Controllers/Controller_1/Hardware/0/11/1:3.Forced", True)"

End Sub

ATP   

answered 11 days ago


 


By RAMA2 on 1/10/2018 | Like (0) | Report

Hi ATP , thanks for your response , I tried it , but it showed problem in the code, I did another solution , I run from PPA Values and from some VBA codes I could access the info and run the report properly

Regards


Add New Comment



Get weekly AKS updates


Partner Exclusive Webinars

 

> – Login to the partner portal to register



Points Redemption Program - Redeem your points for ABB training, Bluetooth speakers and mugs. Terms and conditions >


Earn points when you refer a friend
AKS Referral Program is "Live" - Learn more



AKS Experts


avatar
Ask nikismith   

Rank: 256

I have been a part of the Recording & Control Factory team for 17 years in total, having spent a number of years as a repairs technician withi the manufacturing department, but being in my current role for 9 years now.


avatar
Ask Dieter Henkel   

Rank: 22


avatar
Ask MMM   

Rank: 5

ABB PA CT Technical Support


avatar
Ask Rob Lyon   

Rank: 3

info@lymac.co.nz I'm an independent DCS software and commissioning engineer with extensive experience in 800xA and other ABB products. I've worked in almost every corner of the world and still haven't seen it all.


avatar
Ask kstoilov   

Rank: 12

Control System Engineer: 800xA, Compact 800, AC500, AC31-50, Advant Master, Simatic, AC&DC Drives 11 years worked for ABB - Control Systems


avatar
Ask Govindaraj   

Rank: 10

Working in ABB India Operation Center. Have Project engineering and commissioning experience in ABB 800xA, Freelance, AC500.


avatar
Ask Harsha.D   

Rank: 7

Tech.Support,software and commisioning engineer with Proficient knowledge in 800xA and its products, RNRP,Networking in general.


avatar
Ask Flavio Mussolin   

Rank: 4

ABB AVP, Senior Electronic and Automation Engineer with over 30 years of experience in the field of process automation automotive, pharmaceutical, hollow glass, steel and rolling.


avatar
Ask Stefan Stromqvist   

Rank: 1

I joined ABB in the year of 1994 and has since 1999 been working as a Service & Support Engineer at BU Control Technologies in Västerås, Sweden. My areas of expertise are: 800xA Base, 800xA for Advant Master, Information Management, operating systems, RNRP and Ethernet comms/networking in general.


avatar
Ask Sumit Gargav   

Rank: 2

I have worked with Freelance in majority, with 800xA FD and Melody system partly. Also had opportunity to work with Protocols - HART,Profibus,FF & Modbus.


avatar
Ask Ronny Lindström   

Rank: 20

ABB Service Engineer


avatar
Ask WvanWees   

Rank: 6

I'm a senior service engineer working for ABB in The Netherlands.