AnsweredAssumed Answered

PI Steam Tables and Excel VBA

Question asked by nmosher on Dec 19, 2017
Latest reply on Dec 21, 2017 by nmosher

I'm successfully using the StmEng_HPT function in VBA, but I get a run-time error when the inputs are out of range.  The documentation says that the PI Server will return -1 in this case, but I'm getting a run-time error for "Argument value out of range".  How do I properly handle this error in VBA?  I would like to test whether or not the values are out of range, and do something different if they are without stopping the rest of my code from executing.

 

Thanks,

- Nick

Outcomes