2 Replies Latest reply on May 20, 2018 4:05 PM by Dubus

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

    Dubus

      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