Hello there,

I use "Compressed Data (Start Time/End Time)" in PI Datalink to get the archived alarm statements.

=PICompDat($B$3,$B$1,$B$2, 9,"servername","inside")

B3: Tag Name B1: Start Time B2: End Time




Then I search for a particular word in the alarms (say high or low) and get the corresponding event. I want to do this automatically for a list of alarm tags. The macro will get the tag from a cell , get the archived data , do a word search , get the event and then go to the next tag.

My problem with this is when I change the tag name , the archived data columns don't update fully.It says "Resize to show all values" so I have to right click and select Recalculate (Resize) Function.
Is there any way to do this job without right clicking.

Please reply,

Kapil.

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.

Hi Kapil,

Depends on your version of Datalink.
Whatever version there is a method that you can call from VBA.... "dlresize".

Note that dlresize is not a normal method for Datalink 4.0 so it can give you unexpected behaviour but mostly should be fine. I believe OSI are planning to add a resize method for Datalink 4.0 in the future.

Cheers,

Rhys.

I used dlresize sub from pidildialogs.xla. It worked.Thanks for the hint.