Looking for VBA help (VBPITimeDat) for PI VBA libraries

Discussion created by amcdonald1 on Aug 26, 2020



I've been trying to do some poking around in the object model in Excel VBA for Pi. I came across the VBPITimeDat function which appears to require the same arguments as the PITimeDat worksheet function. This function appears to be part of PIPC32Class. I'm not quite sure what I am doing wrong but when I try and create an instance of PIPC32Class I get an ActiveX error. Am I barking up the wrong tree with VBPITimeDat in PIPC32? Is there another way to get the PITimeDat data via VBA script (w/o posting data to the Excel worksheet and collecting it)?