can someone help me the procedure for sending Excel data value to PI server by VBA??
The datalink installation comes with an example spreadsheet that does exactly that. Please navigate to %pihome%\datalink folder and you'll find an example spreadsheet.
All in all the function are you after is the piputvalx function of which the documentation can be found here: piputvalx
Please give it a look.
Retrieving data ...