AnsweredAssumed Answered

EXCEL VBA PIPutVal - wrong connection to the server. It tries to connect to localhost

Question asked by Dubus on May 18, 2018
Latest reply on May 21, 2018 by jyi

Hi,

 

 

I'm using PIPutval in Excel VBA.

I started with the Excel file piexam32.xls in C:\Program Files (x86)\PIPC\Excel.

I use the command : macroResult = Application.Run("PIPutValx", sTagname, valueCell, stime, sServer, resultCell)

But the result = "Cannot connect to server " and it gives my pc name and not the server name as it's put in sServer variable.

In Visual Basic, I did Break and Step Over to follow the values in variables and all is correct.

 

In PI-SMT, Log Message, I can see a successful login with Excel.exe and my laptop.

Does someone have already this issue ?

 

Thank you very much.

 

 

Jef

 

PI Server 2017R2

Excel 2016

Outcomes