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.

RJK Solutions, RapidPI.

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.