Customers have been using DLResize in the VBA pidldialogs.xla project which is unsupported. It would be nice to create a programmatic access layer so that things such as DLResize can be done in a supported way. It would also be helpful to have programmatic access to automatic update settings and automatic update on/off button.
Note: This was previously Enhancement 19897OSI830 votes
To clarify the previous status, programmatic access to the functionality provided by DLResize and DLSelect from pidialogs.xla is available using ResizeRange and SelectRange beginning in PI DataLink 2014. For details, please see KB01035:
However, programmatic access to the automatic update settings or button has not been implemented.
Create a way to programmatically set the Datalink Settings so that they can automate excel reporting more effectively9 votes
Excel VBA code can invoke the resize/recalculate function on Datalink array formulae. However this requires selection of the array and this pulls the appropriate Task Pane into view (unless the Datalink setting is in force that turns this off). It would be good if the VBA code could hide this Task Pane, but trying to do this currently causes an exception. See PI Square thread: https://pisquare.osisoft.com/message/116861-re-is-there-a-way-to-force-a-pi-datalink-array-formula-to-recalculateresize-using-vba-automation1 vote
- Don't see your idea?