AnsweredAssumed Answered

With PI Datalink can I create a button in Excel that uses VBA code to update the values from Sampled Data?

Question asked by ahmarM on Jan 8, 2020
Latest reply on Jan 8, 2020 by LalBabuShaik(LBS)

Hello, I am creating a spreadsheet using PI data link that updates the values from tags grabbed from the pi archive. I am using Sampled Data to retrieve the values for the last 24 hour every hour. Currently when I hit Apply in the sampled data tab, the values in the spreadsheet update. However, I would like create a button in excel that does what the apply button does just on the spreadsheet itself. In short, how do I reference the pi datalink functions for sampled data in VBA?

Outcomes