2012年6月11日 · Voting to close, since "how do I get the value of pi" is so trivial as to be a useless question, and "how do I calculate pi" is not programming related. The question is …

2022年5月27日 · The first result is the more accurate result looking at the longer value of PI (2 * 3.141592653589793 = 6.283185307179586 which would round to 59). Any explanation for the …

VBA Code to Fill A Range with PI Values (Very Fast!) 8 years ago by JamesDevine At various times my colleagues and I have encountered extended processing times populating a range in …

This simple VBA code snippet will allow you to connect to your PI Data Archive and populate a target cell with the PI Data Archive Name. You will first need to add the following "references" …

2023年8月23日 · If you do not use the PI Asset Framework, you can use PI OLEDB Provider. I have a blog post about how to get started with PI SQL Client in Excel. To minimize the amount …

As a side note, some alternatives for getting PI data in VBA directly could be to either use ADO Recordsets with PI OLEDB Enterprise, or perhaps to use the PI SDK. With these, you will …

But this wouldn't solve my problem, it would just move the problem to the other function, like you said. To test if it may work, remove all the references to PI from the VBA Project. This will …

The PISDKDlg.Connections.Login method logs into the specified PI server using the specified PI user name and password. If the attempt fails, the is presented to allow the user to enter a new …

Thanks, understood the root cause. Is it possible to install PI Processbook 2014 without uninstalling PB 2015 R3 on the same machine. What happens if any organization does silent …

Did you ever try calling PI Web API from VBA within ProcessBook itself? Raymond Verhoeff. I just tested with PI ProcessBook and it also works, added the file to this post. Added details about …