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()



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

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


asked 3 months ago




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


answered 3 months 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


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

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.

Ask Govindaraj   

Rank: 9

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

Ask MMM   

Rank: 5

ABB PA CT Technical Support

Ask kstoilov   

Rank: 11

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

Ask Harsha.D   

Rank: 7

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

Ask Sumit Gargav   

Rank: 3

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.

Ask nikismith   

Rank: 255

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.

Ask Dieter Henkel   

Rank: 19

Ask WvanWees   

Rank: 6

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

Ask Ronny Lindström   

Rank: 16

ABB Service Engineer

Ask Rob Lyon   

Rank: 2

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.

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.