1 of 1 people found this helpful
Could you verify if you are not running into this KB01443 PI DataLink Input Functions Fail to Write to Float or Integer Tags When Default PI AF Server Can't Be Automatically Connected, and verify you have the PI AF and PI Data Archive configured correctly in the connection manager.
Check as well at which connections you are. I was connected to a local database too.
I have not used this excel file in a while but I believe that you need to specify which PI server that you wish to write your data to.
That is specified in the Root Path: Path
What do you have in this 'Path' cell (E21, in my case)? Does it make any difference if you put your PI server name here?
Or what if you give your server name instead of sServer3? (like: Application.Run("PIPutValx", sTagname, valueCell, stime, "myPIServerName", resultCell)