Hello PI Guys,
I want to get min , max , descriptor for a tag given in Cell A1. Eventhough we can use the built in functions of PI Datalink, I have to automate the reports which need such a macro.
the functions of PI Datalink can reference cells. If you for example put the following formula in a cell =PITagAtt($A$5,"descriptor",$A$1) it will show you the descriptor of the tag in cell A5 from server A1.
I just wanted to make sure this addressed your question - do you need any further assistance on this topic?
If you need to develop something in Excel (some VBA code or a .NET add-in) that makes use of PI DataLink functions, then I invite you to post your questions in this same forum. For generic PI DataLink usage questions, I invite you to contact our Technical Support team.
I am satisfied with the answer given by your team and its easier to use the Datalink instead of VBA code.
I won't hesitate to ask a VBA problem if I come across any.
Retrieving data ...