fkeereweer

Write to PI Collective with Excel/ Datalink

Discussion created by fkeereweer on Oct 26, 2009
Latest reply on Oct 27, 2009 by RJKSolutions

Hello,

 

I read the discussion about 'HA Manual Data Entry: Using the PI-SDK (Part 1)'. My question is: how can this be replicated in VBA? In our prior situation there was one PI server and the next VBA code worked fine:

Result = Application.Run("PIPutValx", sTagname, valueCell, stime, ServerName, resultCell)

In the current situation the VBA code has to deal with a collective of two PI servers. First I tried to simply duplicate the code, like this:

Result = Application.Run("PIPutValx", sTagname, valueCell, stime, ServerName1, resultCell)
Result = Application.Run("PIPutValx", sTagname, valueCell, stime, ServerName2, resultCell)

Unfortunately, this doesn't work. The values are only written to the primary server. Would anybody help me with this issue? Thanks in advance!

 

Kind regards,

 

Frits

Outcomes