AnsweredAssumed Answered

How to make a report with Excel DataLink + VBA

Question asked by Kopko on Aug 21, 2017
Latest reply on Aug 24, 2017 by jru

Hello, I'm new to PI and I'm struggling to make something happen.


I have a lot of formulas with tags like this: "If 'tag1' = "on" and ('tag2' = "off" or 'tag3' = "off") then 0 else 1"

And what I want to do is to write a code in visual basic that returns all the formulas that resulted in "0" in a report, could be in the same sheet.

 

My problem is that I don't know how to make the syntax (programming VBA with PI Tags) connecting to the server, getting credentials, working with pi tags and etcetera.

Could someone help me please?

 

Thanks a lot!

Outcomes